ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF633869E053B46B63588994Y select DISTINCT mtrh.request_number, mtrh.header_status, mtrh.header_id HEADER_ID1, hrl.address_line_1 || decode(hrl.address_line_2, null, '', hrl.address_line_2 || ', ') || hrl.address_line_3 || ', ' || hrl.town_or_city || ', ' || hrl.region_2 || ' ' || hrl.postal_code || ', ' || te.territory_short_name address_line, hr2.name, mln.meaning FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, hr_locations hrl, hr_organization_units hr2, fnd_territories_vl te, mtl_trx_types_view mttv, mtl_material_transactions mmt, mfg_lookups mln WHERE mtrh.ship_to_location_id = hrl.location_id AND te.territory_code = hrl.country AND mtrh.header_id = mtrl.header_id AND hr2.organization_id = mtrh.organization_id AND mtrh.header_status = mln.LOOKUP_CODE AND mln.LOOKUP_TYPE = 'MTL_TXN_REQUEST_STATUS' AND mln.meaning in ('Approved', 'Closed', 'Canceled') AND mtrl.quantity_delivered > 0 AND mmt.move_order_line_id = mtrl.line_id AND mttv.transaction_action_id = 1 AND mttv.transaction_source_type_id = 4 AND mttv.type_class = 1 AND mttv.transaction_type_id = mtrh.transaction_type_id &L_WHERE_CLAUSE1 ORDER BY mtrh.request_number CSE CSEBOFLD_XML AR CSE تقرير بوليصة الشحن (بتنسيق XML) Application: تتبع الأصل Source: تقرير بوليصة الشحن (بتنسيق XML) Short Name: CSEBOFLD_XML DB package: CSE_CSEBOFLD_XMLP_PKG D CSE Frachtbrief Application: Asset Tracking Source: Frachtbrief (XML) Short Name: CSEBOFLD_XML DB package: CSE_CSEBOFLD_XMLP_PKG F CSE Etat Bordereau de chargement Application: Asset Tracking Source: Etat Bordereau de chargement (XML) Short Name: CSEBOFLD_XML DB package: CSE_CSEBOFLD_XMLP_PKG US CSE Bill of Lading Application: Asset Tracking Source: Bill of Lading Report (XML) Short Name: CSEBOFLD_XML DB package: CSE_CSEBOFLD_XMLP_PKG ZHS CSE 提单报表 Application: 资产跟踪 Source: 提单报表 (XML) Short Name: CSEBOFLD_XML DB package: CSE_CSEBOFLD_XMLP_PKG BI Publisher &l_where_clause1 :l_where_clause1 :l_where_clause2 :p_conc_request_id :p_from :p_location_code :p_meaning :p_move_order :p_organization_name :p_project_number :p_task_number :p_to 1 10 :p_move_order LOV Oracle CSE_MOVE_ORDER_NO Y select request_number id, request_number value, null description from mtl_txn_request_headers where header_status in (select lookup_code from mfg_lookups where lookup_type='MTL_TXN_REQUEST_STATUS' and meaning in ('Approved','Canceled','Closed') ) order by value,description AR طلب النقل D Transferauftrag F Ordre de transfert US Move Order ZHS 物料搬运单 2 20 :p_meaning LOV Oracle CSE_MOVE_ORDER_STATUS Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MFG_TXN_REQUEST_STATUS' and meaning in ('Approved','Closed','Canceled') order by value,description AR موقف طلب النقل D Transferauftragsstatus F Statut de l'ordre de transfert US Move Order Status ZHS 物料搬运单状态 3 30 :p_organization_name LOV Oracle CSE_ORG_NAME Y select a.name id, a.name value, null description from (select distinct name from hr_all_organization_units) a order by value,description AR اسم التنظيم D Organisationsbezeichnung F Nom de l'organisation US Organization Name ZHS 组织名 4 40 :p_from Date AR من تاريخ D Von Datum F Date de début US Date From ZHS 日期自 5 50 :p_to Date AR إلى تاريخ D Bis Datum F Date de fin US Date To ZHS 日期至 6 60 :p_project_number LOV Oracle CSE_PROJECT_NUMBERS_BOL Y select segment1 id, segment1 value, null description from pa_projects_all order by value,description AR رقم المشروع D Projektnummer F Numéro de projet US Project Number ZHS 项目编号 7 70 :p_task_number LOV Oracle CSE_TASK_NUMBER_BOL Y select distinct(task_number) id, task_number value, null description from pa_tasks_expend_v where project_id in (select project_id from pa_projects_expend_v where project_number=:$flex$.cse_project_numbers_bol) order by value,description AR رقم المهمة D Teilprojektnummer F Numéro de tâche US Task Number ZHS 任务编号