ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F04D3869E053B46B63588994Y SELECT ship ,ipr.ship_header_id ,to_char(ship_date,'DD-MON-YYYY') ship_date ,organization_id ,organization_code ,q1.organization_name ,slg_num ,ship_line_group_reference ,ship_line_src_type_code ,line ,alloc ,(SELECT distribution_num FROM po_distributions_all WHERE po_distribution_id = ipr.po_dist) po_dist ,type ,( SELECT meaning FROM fnd_lookup_values_vl flv WHERE flv.lookup_type = 'INL_COMPONENT_TYPES' AND flv.lookup_code = decode(ipr.type,'ITEM PRICE', 'ITEM',ipr.type) ) component_type ,ref ,item ,to_char (elc,q1.get_format_mask) elc_f ,to_number(to_char (elc,q1.get_format_mask),q1.get_format_mask) elc ,to_char (billed,q1.get_format_mask) billed ,to_char (decode(show_alc,0,null,alc),q1.get_format_mask) alc_f ,to_number(to_char (decode(show_alc,0,null,alc),q1.get_format_mask),q1.get_format_mask) alc ,to_number(nvl(to_char (to_number(to_char (nvl(decode(show_alc,0,null,alc),0),q1.get_format_mask),q1.get_format_mask)-to_number(to_char (nvl(elc,0),q1.get_format_mask),q1.get_format_mask),q1.get_format_mask),0),q1.get_format_mask) lc_variance ,rtrim(to_char(prim_quantity,'FM9999999999.9999999999') ,'.') prim_quantity ,line_primary_quantity ,rtrim(to_char(line_primary_quantity,'FM9999999999.9999999999') ,'.') line_primary_quantity_f ,uom ,project_id ,project_number ,task_id ,task_number ,trx ,party_name ,q1.currency_code ,q1.get_format_mask amt_format_mask ,q1.get_extprecformatmask ulc_amt_format_mask ,show_alc ,countrts ,ship_type_code ,ship_line_type_code FROM inl_po_dist_landed_costs_v ipr, ( SELECT sh.ship_header_id ,sh.adjustment_num ,sh.ship_num ,gsb.currency_code ,ood.organization_name ,fnd_currency_cache.get_format_mask (gsb.currency_code ,30) get_format_mask ,INL_INTEGRATION_GRP.GET_EXTPRECFORMATMASK(gsb.currency_code,30) get_extprecformatmask FROM inl_ship_headers_all sh ,gl_sets_of_books gsb ,org_organization_definitions ood WHERE gsb.set_of_books_id = ood.set_of_books_id AND ood.organization_id = sh.organization_id ) q1 WHERE q1.ship_header_id = ipr.ship_header_id AND NOT (ipr.trx = 'RECEIVE' and ipr.prim_quantity = 0) &LP_ORGANIZATION_ID &LP_SHIP_HEADER_ID &LP_SHIP_DATE &LP_SOURCE_TYPE &LP_ITEM_RANGE &LP_PROJECT_NUMBER &LP_TASK_NUMBER ORDER BY organization_name,ship,slg_num,line,alloc ASC INL INLLCCRP_XML AR INL تقرير تفاصيل التكلفة الكلية (تنسيق XML) Application: إدارة التكلفة العقارية لأوراكل Source: تقرير تفاصيل التكلفة الكلية (تنسيق XML) Short Name: INLLCCRP_XML DB package: INL_INLLCCRP_XMLP_PKG D INL Anlieferungskosten - Details Application: Oracle Landed Cost Management Source: Anlieferungskosten - Details (XML) Short Name: INLLCCRP_XML DB package: INL_INLLCCRP_XMLP_PKG F INL Etat détaillé des coûts en magasin Application: Oracle Landed Cost Management Source: Etat détaillé des coûts en magasin (XML) Short Name: INLLCCRP_XML DB package: INL_INLLCCRP_XMLP_PKG US INL Landed Cost Detail Application: Oracle Landed Cost Management Source: Landed Cost Detail Report (XML) Short Name: INLLCCRP_XML DB package: INL_INLLCCRP_XMLP_PKG ZHS INL 到岸成本详细信息报表 Application: Oracle Landed Cost Management Source: 到岸成本详细信息报表 (XML) Short Name: INLLCCRP_XML DB package: INL_INLLCCRP_XMLP_PKG BI Publisher &lp_item_range &lp_organization_id &lp_project_number &lp_ship_date &lp_ship_header_id &lp_source_type &lp_task_number :lp_item_range :lp_organization_id :lp_project_number :lp_ship_date :lp_ship_header_id :lp_source_type :lp_task_number :p_from_project_number :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_task_number :p_to_project_number :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_from_project_number LOV Oracle INL_PA_PROJECTS Y select segment1 id, segment1 value, null description from pa_projects_all order by value,description US P_FROM_PROJECT_NUMBER 10 100 :p_to_project_number LOV Oracle INL_PA_PROJECTS Y select segment1 id, segment1 value, null description from pa_projects_all order by value,description US P_TO_PROJECT_NUMBER 11 110 :p_task_number LOV Oracle INL_PA_TASKS Y select t.task_number id, t.task_number value, null description from pa_tasks t where t.project_id=( select p.project_id from pa_projects_all p where p.segment1=:$flex$.p_from_project_number) and :$flex$.p_from_project_number=:$flex$.p_to_project_number order by t.task_number AR المهمة D Teilprojekt F Tâche US Task ZHS 任务