INL Unaccounted Landed Costs for Full Returns

Description
Categories: BI Publisher
Columns: To Parent Table Name, To Parent Table Id, To Organization Code, Associated To Header, Associated To Group, Associated To Line, Associated To Receipt, Associated To Receipt Line ...
Application: Oracle Landed Cost Management
Source: Unaccounted Landed Costs for Full Returns (XML)
Short Name: INLRTSCP_XML
DB package: INL_INLRTSCP_XMLP_PKG
SELECT distinct to_parent_table_name
						   ,to_parent_table_id
               ,to_organization_code
						   ,decode (to_parent_table_name
								   ,'INL_SHIP_LINES'
								   ,
									(
									SELECT  ish.ship_num
									FROM    inl_ship_headers_all ish
										   ,inl_ship_lines_all isl
									WHERE   ish.ship_header_id = isl.ship_header_id
									AND     rownum = 1
									AND     isl.ship_line_id = ica.to_parent_table_id
									)
								   ,'INL_SHIP_LINE_ID'
								   ,
									(
									SELECT  ish.ship_num
									FROM    inl_ship_headers_all ish