ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F04F3869E053B46B63588994 SELECT mp.organization_code ,ood.organization_name ,hrl.location_code ,sh.ship_num ,to_char(sh.ship_date,'DD-MON-YYYY') ship_date ,lc.adjustment_num ,to_char( ( SELECT max (a.creation_date) FROM inl_allocations a WHERE lc.ship_header_id = a.ship_header_id AND lc.ship_line_id = a.ship_line_id AND lc.adjustment_num = a.adjustment_num ),'DD-MON-YYYY') adjustment_date ,slg.ship_line_group_num ,hp.party_name ,hps.party_site_name ,lc.ship_line_num ,lc.inv_item ,msi.description item_description ,decode (sl.primary_qty ,0 ,0 ,sum (lc.allocated_amt) / sl.primary_qty) ulc ,to_char (decode (sl.primary_qty ,0 ,0 ,sum (lc.allocated_amt) / sl.primary_qty) ,fnd_currency_cache.get_format_mask (gsb.currency_code ,30)) ulc_f ,sum (lc.allocated_amt) actual_amount ,to_char (sum (lc.allocated_amt) ,fnd_currency_cache.get_format_mask (gsb.currency_code ,30)) actual_amount_f ,sl.primary_qty ,lc.unit_of_measure ,sh.organization_id ,nvl (lc.parent_ship_line_id ,lc.ship_line_id) parent_ship_line_id ,lc.ship_line_id ,lc.ship_header_id ,sh.location_id ,slg.ship_line_group_reference ,slg.party_id ,slg.party_site_id ,sl.ship_line_src_type_code ,nvl (ph.segment1 ,sl.src_document_num) src_document_num ,nvl (pr.release_num ,sl.src_document_version_num) src_document_version_num ,nvl (pl.line_num ,sl.src_document_line_num) src_document_line_num ,nvl (pll.shipment_num ,sl.src_document_line_detail_num) src_document_line_detail_num ,gsb.currency_code funct_currency ,decode (lc.adjustment_num ,sh.adjustment_num ,1 ,0) last_adj ,DECODE(sl.primary_qty, 0,0,(SUM(DECODE(lc.component_type, 'ITEM PRICE',lc.allocated_amt,0))/sl.primary_qty)) unit_price ,to_char (DECODE(sl.primary_qty, 0,0,(SUM(DECODE(lc.component_type, 'ITEM PRICE',lc.allocated_amt,0))/sl.primary_qty)) ,fnd_currency_cache.get_format_mask (gsb.currency_code ,30)) unit_price_f FROM inl_det_landed_costs_v lc ,inl_ship_headers_all sh ,inl_ship_line_groups slg ,inl_ship_lines_all sl ,mtl_parameters mp ,hr_locations_all hrl ,hz_parties hp ,hz_party_sites hps ,mtl_system_items_kfv msi ,po_headers_all ph ,po_releases_all pr ,po_lines_all pl ,po_line_locations_all pll ,org_organization_definitions ood ,gl_sets_of_books gsb WHERE hrl.location_id = sh.location_id AND lc.ship_header_id = sh.ship_header_id AND sh.simulation_id IS NULL AND sh.ship_status_code = 'COMPLETED' AND nvl (sh.pending_matching_flag ,'N') = 'N' AND nvl (sh.pending_update_flag ,'N') = 'N' AND slg.ship_header_id = sh.ship_header_id AND slg.ship_line_group_id = lc.ship_line_group_id AND slg.ship_line_group_id = sl.ship_line_group_id AND sh.organization_id = mp.organization_id AND lc.ship_line_id = sl.ship_line_id AND hp.party_id = slg.party_id AND hps.party_site_id = slg.party_site_id AND msi.organization_id = sh.organization_id AND msi.inventory_item_id = sl.inventory_item_id AND pll.line_location_id (+) = sl.ship_line_source_id AND pl.po_line_id (+) = pll.po_line_id AND pll.po_header_id = ph.po_header_id (+) AND pll.po_release_id = pr.po_release_id (+) AND gsb.set_of_books_id = ood.set_of_books_id AND sh.organization_id = ood.organization_id &LP_ORGANIZATION_ID &LP_SHIP_HEADER_ID &LP_SHIP_DATE &LP_SOURCE_TYPE &LP_ITEM_RANGE &LP_DOC_RANGE &LP_ADJ_INCLUDED &LP_ADJ_DATE GROUP BY mp.organization_code ,ood.organization_name ,hrl.location_code ,sh.ship_num ,sh.ship_date ,lc.adjustment_num ,slg.ship_line_group_num ,hp.party_name ,hps.party_site_name ,lc.ship_line_num ,lc.inv_item ,msi.description ,sl.primary_qty ,lc.unit_of_measure ,sh.organization_id ,nvl (lc.parent_ship_line_id ,lc.ship_line_id) ,lc.ship_line_id ,lc.ship_header_id ,sh.location_id ,slg.ship_line_group_reference ,slg.party_id ,slg.party_site_id ,sl.ship_line_src_type_code ,nvl (ph.segment1 ,sl.src_document_num) ,nvl (pr.release_num ,sl.src_document_version_num) ,nvl (pl.line_num ,sl.src_document_line_num) ,nvl (pll.shipment_num ,sl.src_document_line_detail_num) ,gsb.currency_code ,decode (lc.adjustment_num ,sh.adjustment_num ,1 ,0) ORDER BY mp.organization_code ,sh.ship_num ,slg.ship_line_group_num ,lc.ship_line_num ,lc.adjustment_num Y INL INLSLCRP_XML Y AR INL تقرير إجمالي التكلفة الكلية (تنسيق XML) Application: إدارة التكلفة العقارية لأوراكل Source: تقرير إجمالي التكلفة الكلية (تنسيق XML) Short Name: INLSLCRP_XML DB package: INL_INLSLCRP_XMLP_PKG D INL Anlieferungskosten - Übersicht Application: Oracle Landed Cost Management Source: Anlieferungskosten - Übersicht (XML) Short Name: INLSLCRP_XML DB package: INL_INLSLCRP_XMLP_PKG F INL Etat de synthèse des coûts en magasin Application: Oracle Landed Cost Management Source: Etat de synthèse des coûts en magasin (XML) Short Name: INLSLCRP_XML DB package: INL_INLSLCRP_XMLP_PKG US INL Landed Cost Summary Application: Oracle Landed Cost Management Source: Landed Cost Summary Report (XML) Short Name: INLSLCRP_XML DB package: INL_INLSLCRP_XMLP_PKG ZHS INL 到岸成本汇总报表 Application: Oracle Landed Cost Management Source: 到岸成本汇总报表 (XML) Short Name: INLSLCRP_XML DB package: INL_INLSLCRP_XMLP_PKG BI Publisher &lp_adj_date &lp_adj_included &lp_doc_range &lp_item_range &lp_organization_id &lp_ship_date &lp_ship_header_id &lp_source_type :lp_adj_date :lp_adj_included :lp_doc_range :lp_item_range :lp_organization_id :lp_ship_date :lp_ship_header_id :lp_source_type :p_adj_date_from :p_adj_date_to :p_adj_val :p_doc_num_from :p_doc_num_to :p_from_ship_date :p_item_num_from :p_item_num_to :p_organization_id :p_shipment_from :p_shipment_to :p_source_type :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_source_type LOV Oracle INL_SL_SRC_TYPE_CODE Y select lookup_code id, lookup_code value, description description from fnd_lookup_values_vl where lookup_type='INL_SHIP_LINE_SRC_TYPES' and enabled_flag='Y' order by value,description AR نوع المصدر D Herkunftsart F Type d'origine US Source Type ZHS 来源类型 7 70 :p_item_num_from LOV Oracle INL_ITEM_NUMBER Y select concatenated_segments id, concatenated_segments value, description description from mtl_system_items_kfv where organization_id=:$flex$.inl_inv_org order by value,description AR الصنف من D Von Artikel F Article - De US Item From ZHS 物料自 8 80 :p_item_num_to LOV Oracle INL_ITEM_NUMBER Y select concatenated_segments id, concatenated_segments value, description description from mtl_system_items_kfv where organization_id=:$flex$.inl_inv_org order by value,description AR الصنف إلى D Bis Artikel F Article - A US Item To ZHS 物料至 9 90 :p_doc_num_from Char AR أمر الشراء/المستند من D Von Dokument/Bestellung F Document/Ordre d'achat - De US Document/Purchase Order From ZHS 单据/采购订单自 10 100 :p_doc_num_to Char AR أمر الشراء/المستند إلى D Bis Dokument/Bestellung F Document/Ordre d'achat - A US Document/Purchase Order To ZHS 单据/采购订单至 11 110 :p_adj_val LOV Oracle INL_ADJ_INCLUDED Y select lookup_code id, description value, null description from fnd_lookup_values_vl where lookup_type='INL_ADJUSTMENTS_INCLUDED' order by value,description ALL Y AR التعديلات D Korrekturen F Ajustements US Adjustments ZHS 调整 12 120 :p_adj_date_from Date AR تاريخ التعديل من D Von Korrekturdatum F Date d'ajustement - Du US Adjustment Date From ZHS 调整日期自 13 130 :p_adj_date_to Date AR تاريخ التعديل إلى D Bis Korrekturdatum F Date d'ajustement - Au US Adjustment Date To ZHS 调整日期至 :$flex$.inl_inv_org Inventory Organization Item From :$flex$.inl_inv_org Inventory Organization Item To :$flex$.inl_inv_org Inventory Organization Shipment From :$flex$.inl_inv_org Inventory Organization Shipment To