ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F04E3869E053B46B63588994Y 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 ,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_GROUPS' , ( SELECT ish.ship_num FROM inl_ship_headers_all ish ,inl_ship_line_groups isg WHERE ish.ship_header_id = isg.ship_header_id AND rownum = 1 AND isg.ship_line_group_id = ica.to_parent_table_id ) ,'INL_SHIP_HEADERS' , ( SELECT ish.ship_num FROM inl_ship_headers_all ish WHERE ish.ship_header_id = ica.to_parent_table_id ) ,NULL) associated_to_header ,decode (to_parent_table_name ,'INL_SHIP_LINES' , ( SELECT isg.ship_line_group_num FROM inl_ship_line_groups isg ,inl_ship_lines_all isl WHERE isg.ship_line_group_id = isl.ship_line_group_id AND isl.ship_line_id = ica.to_parent_table_id ) ,'INL_SHIP_LINE_ID' , ( SELECT isg.ship_line_group_num FROM inl_ship_line_groups isg ,inl_ship_lines_all isl WHERE isg.ship_line_group_id = isl.ship_line_group_id AND isl.ship_line_id = ica.to_parent_table_id ) ,'INL_SHIP_LINE_GROUPS' , ( SELECT ship_line_group_num FROM inl_ship_line_groups WHERE ship_line_group_id = ica.to_parent_table_id ) ,'INL_SHIP_HEADERS' ,NULL ,NULL) associated_to_group ,decode (to_parent_table_name ,'INL_SHIP_LINES' , ( SELECT isl.ship_line_num FROM inl_ship_lines_all isl WHERE isl.ship_line_id = ica.to_parent_table_id ) ,'INL_SHIP_LINE_ID' , ( SELECT isl.ship_line_num FROM inl_ship_lines_all isl WHERE isl.ship_line_id = ica.to_parent_table_id ) ,'INL_SHIP_LINE_GROUPS' ,NULL ,'INL_SHIP_HEADERS' ,NULL ,NULL) associated_to_line ,decode (to_parent_table_name ,'INL_SHIP_LINES' , ( SELECT rsh.receipt_num FROM rcv_shipment_headers rsh ,rcv_shipment_lines rsl ,inl_ship_lines_all isl WHERE nvl (isl.parent_ship_line_id,isl.ship_line_id) = rsl.lcm_shipment_line_id AND rsl.shipment_header_id = rsh.shipment_header_id and isl.ship_line_id =ica.to_parent_table_id ) ,'INL_SHIP_LINE_ID' , ( SELECT rsh.receipt_num FROM rcv_shipment_headers rsh ,rcv_shipment_lines rsl ,inl_ship_lines_all isl WHERE nvl (isl.parent_ship_line_id,isl.ship_line_id) = rsl.lcm_shipment_line_id AND rsl.shipment_header_id = rsh.shipment_header_id and isl.ship_line_id =ica.to_parent_table_id ) ,'INL_SHIP_LINE_GROUPS' ,NULL ,'INL_SHIP_HEADERS' ,NULL ,NULL) associated_to_receipt ,decode (to_parent_table_name ,'INL_SHIP_LINES' , ( SELECT rsl.line_num FROM rcv_shipment_headers rsh ,rcv_shipment_lines rsl ,inl_ship_lines_all isl WHERE nvl (isl.parent_ship_line_id,isl.ship_line_id) = rsl.lcm_shipment_line_id AND rsl.shipment_header_id = rsh.shipment_header_id and isl.ship_line_id =ica.to_parent_table_id ) ,'INL_SHIP_LINE_ID' , ( SELECT rsl.line_num FROM rcv_shipment_headers rsh ,rcv_shipment_lines rsl ,inl_ship_lines_all isl WHERE nvl (isl.parent_ship_line_id,isl.ship_line_id) = rsl.lcm_shipment_line_id AND rsl.shipment_header_id = rsh.shipment_header_id and isl.ship_line_id =ica.to_parent_table_id ) ,'INL_SHIP_LINE_GROUPS' ,NULL ,'INL_SHIP_HEADERS' ,NULL ,NULL) associated_to_receipt_line FROM inl_component_amounts_v ica WHERE component_type = :component_type AND component_id = :component_id AND component_code = :component_code AND component_amt = :component_amt AND abs (ica.component_amt) > 0.000001 AND ica.component_allocated_amt = 0 order by associated_to_header,associated_to_group,associated_to_line,associated_to_receipt,associated_to_receipt_line INL INLRTSCP_XML AR INL التكاليف الكلية غير المحتسبة للمرتجعات بالكامل بتنسيق Application: إدارة التكلفة العقارية لأوراكل Source: التكاليف الكلية غير المحتسبة للمرتجعات بالكامل بتنسيق (XML) Short Name: INLRTSCP_XML DB package: INL_INLRTSCP_XMLP_PKG D INL Nicht gebuchte Anlieferungskosten für vollständige Rücksendungen Application: Oracle Landed Cost Management Source: Nicht gebuchte Anlieferungskosten für vollständige Rücksendungen (XML) Short Name: INLRTSCP_XML DB package: INL_INLRTSCP_XMLP_PKG F INL Coûts en magasin non comptabilisés pour les retours complets Application: Oracle Landed Cost Management Source: Coûts en magasin non comptabilisés pour les retours complets (XML) Short Name: INLRTSCP_XML DB package: INL_INLRTSCP_XMLP_PKG US INL Unaccounted Landed Costs for Full Returns Application: Oracle Landed Cost Management Source: Unaccounted Landed Costs for Full Returns (XML) Short Name: INLRTSCP_XML DB package: INL_INLRTSCP_XMLP_PKG ZHS INL 完全退货的未入账到岸成本 Application: Oracle Landed Cost Management Source: 完全退货的未入账到岸成本 (XML) Short Name: INLRTSCP_XML DB package: INL_INLRTSCP_XMLP_PKG BI Publisher :component_amt :component_code :component_id :component_type :lp_component_code :lp_organization_id :lp_organization_id1 :lp_organization_id2 :lp_ship_date :lp_ship_header_id :lp_third_party :lp_third_party_site :p_component_code :p_from_party_site_name :p_from_ship_date :p_organization_id :p_party_id :p_shipment_from :p_shipment_to :p_to_party_site_name :p_to_ship_date 1 10 :p_organization_id LOV Oracle INL_INV_ORG Y select organization_id id, organization_name value, null description from org_access_view where responsibility_id=fnd_global.resp_id and resp_application_id=fnd_global.resp_appl_id and exists (select 1 from mtl_parameters m where m.organization_id=org_access_view.organization_id and m.lcm_enabled_flag='Y' and rownum<2) order by value,description AR تنظيم المخازن D Lagerorganisation F Organisation logistique US Inventory Organization ZHS 库存组织 2 20 :p_shipment_from LOV Oracle INL_SHIP_NUM Y select ship_num id, ship_num value, null description from inl_ship_headers_all where organization_id=:$flex$.inl_inv_org and simulation_id is null order by ship_num AR الشحنة من D Von Lieferung F Expédition - De US Shipment From ZHS 发运自 3 30 :p_shipment_to LOV Oracle INL_SHIP_NUM Y select ship_num id, ship_num value, null description from inl_ship_headers_all where organization_id=:$flex$.inl_inv_org and simulation_id is null order by ship_num AR الشحنة إلى D Bis Lieferung F Expédition - A US Shipment To ZHS 发运至 4 40 :p_from_ship_date Date AR تاريخ الشحنة من D Lieferdatum von F Date d'expédition - Du US Shipment Date From ZHS 发运日期自 5 50 :p_to_ship_date Date AR تاريخ الشحنة إلى D Lieferdatum bis F Date d'expédition - Au US Shipment Date To ZHS 发运日期至 6 60 :p_party_id LOV Oracle INL_PARTY_ID Y select party_id id, party_name value, null description from hz_parties where exists ( select 1 from inl_ship_headers_all sh, inl_ship_line_groups slg where sh.ship_header_id=slg.ship_header_id and hz_parties.party_id=slg.party_id and organization_id=:$flex$.inl_inv_org ) order by party_name AR الطرف الآخر D Geschäftspartner F Tiers US Third Party ZHS 第三方 7 70 :p_from_party_site_name LOV Oracle INL_PARTY_SITE_NAME Y select party_site_name id, party_site_name value, null description from hz_party_sites where party_id=:$flex$.inl_party_id and exists ( select 1 from inl_ship_headers_all sh, inl_ship_line_groups slg where sh.ship_header_id=slg.ship_header_id and hz_party_sites.party_site_id=slg.party_site_id and organization_id=:$flex$.inl_inv_org ) order by party_site_name AR موقع الطرف الآخر من D Geschäftspartneradresse von F Site tiers - De US Third Party Site From ZHS 第三方地点自 8 80 :p_to_party_site_name LOV Oracle INL_PARTY_SITE_NAME Y select party_site_name id, party_site_name value, null description from hz_party_sites where party_id=:$flex$.inl_party_id and exists ( select 1 from inl_ship_headers_all sh, inl_ship_line_groups slg where sh.ship_header_id=slg.ship_header_id and hz_party_sites.party_site_id=slg.party_site_id and organization_id=:$flex$.inl_inv_org ) order by party_site_name AR موقع الطرف الثالث إلى D Geschäftspartneradresse bis F Site tiers - A US Third Party Site To ZHS 第三方地点至