ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4623869E053B46B63588994Y select oelines.sold_to_org_id, oelines.ship_to_org_id ship_to_org_id3, nvl(oelines.intmed_ship_to_org_id, -1) intmed_ship_to_org_id, oelines.ship_from_org_id, oelines.inventory_item_id, oelines.ordered_item_id, &LP_Q1_COL1 requirement_date, &LP_Q1_COL2 firm_status, oelines.demand_bucket_type_code, &LP_Q1_COL17 schedule_type, to_number(&LP_Q1_COL3) order_number, to_number(&LP_Q1_COL4) line_number, &LP_Q1_COL5 cust_po_number, to_number(&LP_Q1_COL6) ordered_quantity, &LP_Q1_COL7 order_quantity_uom, to_number(&LP_Q1_COL8) shipped_quantity, &LP_Q1_COL9 shipping_quantity_uom, to_number(&LP_Q1_COL10) fulfilled_quantity, &LP_Q1_COL11 fulfilled_quantity_uom, &LP_Q1_COL12 schedule_reference_num, &LP_Q1_COL13 customer_job, &LP_Q1_COL14 planning_sequence, &LP_Q1_COL15 cust_model_serial_number, &LP_Q1_COL16 customer_record_year, RLM_RLMDMSIQ_XMLP_PKG.customer_nameformula(oelines.sold_to_org_id) customer_name, RLM_RLMDMSIQ_XMLP_PKG.customer_numberformula(oelines.sold_to_org_id) customer_number, RLM_RLMDMSIQ_XMLP_PKG.intmed_ship_to_locationformul(nvl ( oelines.intmed_ship_to_org_id , - 1 )) intmed_ship_to_location, RLM_RLMDMSIQ_XMLP_PKG.intmed_ship_to_nameformula(nvl ( oelines.intmed_ship_to_org_id , - 1 )) intmed_ship_to_name, RLM_RLMDMSIQ_XMLP_PKG.ship_to_locationformula(oelines.ship_to_org_id) ship_to_location, RLM_RLMDMSIQ_XMLP_PKG.ship_to_nameformula(oelines.ship_to_org_id) ship_to_name, RLM_RLMDMSIQ_XMLP_PKG.ship_from_codeformula(oelines.ship_from_org_id) ship_from_code, RLM_RLMDMSIQ_XMLP_PKG.ship_from_nameformula(oelines.ship_from_org_id) ship_from_name, RLM_RLMDMSIQ_XMLP_PKG.concatenated_segmentsformula(oelines.inventory_item_id, oelines.ship_from_org_id) concatenated_segments, RLM_RLMDMSIQ_XMLP_PKG.descriptionformula(oelines.inventory_item_id, oelines.ship_from_org_id) description, RLM_RLMDMSIQ_XMLP_PKG.customer_item_numberformula(oelines.ordered_item_id) customer_item_number, RLM_RLMDMSIQ_XMLP_PKG.customer_item_descformula(oelines.ordered_item_id) customer_item_desc, RLM_RLMDMSIQ_XMLP_PKG.bucket_type_codeformula(oelines.demand_bucket_type_code) bucket_type_code, RLM_RLMDMSIQ_XMLP_PKG.cf_sched_type(&LP_Q1_COL17) CF_sched_type from oe_order_lines_all oelines, oe_order_headers_all oeheaders, rlm_schedule_lines_all schlines, rlm_schedule_headers schheaders where oelines.header_id = oeheaders.header_id and oelines.authorized_to_ship_flag = 'Y' and oelines.source_document_id = schlines.header_id and oelines.source_document_line_id = schlines.line_id and schlines.header_id = schheaders.header_id and oelines.item_identifier_type = 'CUST' and schheaders.org_id = schlines.org_id and schheaders.org_id = oeheaders.org_id and schheaders.org_id = oelines.org_id &LP_Q1_LINES &P_WHERE_CLAUSE1 &P_WHERE_CLAUSE2 &LP_Q1_GROUP_BY ORDER BY 1 ASC,3 ASC,2 ASC,4 ASC,6 ASC,5 ASC RLM RLMDMQRY_XML AR RLM تقرير الاستعلام عن موقف الطلبات Application: إدارة بيانات الإصدار Source: تقرير الاستعلام عن موقف الطلبات (XML) Short Name: RLMDMQRY_XML DB package: RLM_RLMDMSIQ_XMLP_PKG D RLM Bedarfsübersicht Application: Release Management Source: Bedarfsübersicht (XML) Short Name: RLMDMQRY_XML DB package: RLM_RLMDMSIQ_XMLP_PKG F RLM Consultation du statut de la demande Application: Release Management Source: Consultation du statut de la demande (XML) Short Name: RLMDMQRY_XML DB package: RLM_RLMDMSIQ_XMLP_PKG US RLM Demand Status Inquiry Application: Release Management Source: Demand Status Inquiry Report (XML) Short Name: RLMDMQRY_XML DB package: RLM_RLMDMSIQ_XMLP_PKG ZHS RLM 需求状态查询报表 Application: 发放管理 Source: 需求状态查询报表 (XML) Short Name: RLMDMQRY_XML DB package: RLM_RLMDMSIQ_XMLP_PKG BI Publisher &lp_q1_col1 &lp_q1_col10 &lp_q1_col11 &lp_q1_col12 &lp_q1_col13 &lp_q1_col14 &lp_q1_col15 &lp_q1_col16 &lp_q1_col17 &lp_q1_col2 &lp_q1_col3 &lp_q1_col4 &lp_q1_col5 &lp_q1_col6 &lp_q1_col7 &lp_q1_col8 &lp_q1_col9 &lp_q1_group_by &lp_q1_lines &p_where_clause1 &p_where_clause2 :cp_default_ou :cp_p_customer_name :cp_p_deliver_to :cp_p_ship_from :cp_p_ship_to :lp_q1_col1 :lp_q1_col10 :lp_q1_col11 :lp_q1_col12 :lp_q1_col13 :lp_q1_col14 :lp_q1_col15 :lp_q1_col16 :lp_q1_col17 :lp_q1_col2 :lp_q1_col3 :lp_q1_col4 :lp_q1_col5 :lp_q1_col6 :lp_q1_col7 :lp_q1_col8 :lp_q1_col9 :lp_q1_group_by :lp_q1_lines :lp_q2_col1 :lp_q2_col10 :lp_q2_col11 :lp_q2_col2 :lp_q2_col3 :lp_q2_col4 :lp_q2_col5 :lp_q2_col6 :lp_q2_col7 :lp_q2_col8 :lp_q2_col9 :lp_q2_group_by :operating_unit :p_conc_request_id :p_cust_or_inv_item :p_customer_id :p_deliver_to_org_id :p_from_item_id :p_from_order :p_from_ship_date :p_incl_cancel_lines :p_incl_curr_res_authzns :p_org_id :p_req_firm_forecast_both :p_ship_from_org_id :p_ship_to_org_id :p_ship_unship_both :p_sum_date_and_bucket :p_title :p_to_item_id :p_to_order :p_to_ship_date :p_where_clause1 :p_where_clause2 1 10 :p_title Char Demand Status Inquiry Report AR العنوان D Titel F Titre US Title ZHS 标题 2 20 :p_ship_from_org_id LOV Oracle RLM_SHIP_FROM_ORG Y select organization_id id, organization_code value, organization_name description from org_organization_definitions order by organization_code,organization_name AR شحن من D Liefern von F Expédition US Ship From ZHS 发货方 3 30 :p_customer_id LOV Oracle RLM_CUSTOMER Y select cust_account_id id, party.party_name value, account_number description from hz_parties party,hz_cust_accounts cust_acct where cust_acct.party_id=party.party_id order by party.party_name,account_number AR اسم العميل D Kundenname F Nom du client US Customer Name ZHS 客户名称 4 40 :p_ship_to_org_id LOV Oracle RLM_SHIP_TO_ORG_IDS Y select cust_site.site_use_id id, acct_site.ece_tp_location_code value, null description from hz_party_sites party_site,hz_locations loc,hz_cust_acct_sites acct_site,hz_cust_site_uses_all cust_site where ( :$flex$.rlm_customer:null is null and acct_site.status='A' and cust_site.cust_acct_site_id=acct_site.cust_acct_site_id and acct_site.party_site_id=party_site.party_site_id and loc.location_id=party_site.location_id and cust_site.site_use_code='SHIP_TO' and acct_site.org_id=cust_site.org_id ) or ( :$flex$.rlm_customer:null is not null and acct_site.cust_account_id in ( select to_number(:$flex$.rlm_customer:null) from dual union select cust_account_id from hz_cust_acct_relate where related_cust_account_id=:$flex$.rlm_customer:null and ship_to_flag='Y' and status='A' and oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG') in ('Y','A')) and acct_site.status='A' and cust_site.cust_acct_site_id=acct_site.cust_acct_site_id and acct_site.party_site_id=party_site.party_site_id and loc.location_id=party_site.location_id and cust_site.site_use_code='SHIP_TO' and acct_site.org_id=cust_site.org_id ) order by acct_site.ece_tp_location_code AR شحن إلى D Liefern an F Livraison US Ship To ZHS 收货方 5 50 :p_deliver_to_org_id LOV Oracle RLM_SHIP_TO_ORG_IDS Y select cust_site.site_use_id id, acct_site.ece_tp_location_code value, null description from hz_party_sites party_site,hz_locations loc,hz_cust_acct_sites acct_site,hz_cust_site_uses_all cust_site where ( :$flex$.rlm_customer:null is null and acct_site.status='A' and cust_site.cust_acct_site_id=acct_site.cust_acct_site_id and acct_site.party_site_id=party_site.party_site_id and loc.location_id=party_site.location_id and cust_site.site_use_code='SHIP_TO' and acct_site.org_id=cust_site.org_id ) or ( :$flex$.rlm_customer:null is not null and acct_site.cust_account_id in ( select to_number(:$flex$.rlm_customer:null) from dual union select cust_account_id from hz_cust_acct_relate where related_cust_account_id=:$flex$.rlm_customer:null and ship_to_flag='Y' and status='A' and oe_sys_parameters.value('CUSTOMER_RELATIONSHIPS_FLAG') in ('Y','A')) and acct_site.status='A' and cust_site.cust_acct_site_id=acct_site.cust_acct_site_id and acct_site.party_site_id=party_site.party_site_id and loc.location_id=party_site.location_id and cust_site.site_use_code='SHIP_TO' and acct_site.org_id=cust_site.org_id ) order by acct_site.ece_tp_location_code AR شحن وسيط إلى D Zwischenlager F Livraison intermédiaire US Intermediate Ship To ZHS 中转收货方 6 60 :p_from_order LOV Oracle RLM_ORDER_NUMBER Y select oh.order_number id, oh.order_number value, null description from oe_order_headers oh,oe_order_types_v ot where oh.order_type_id=ot.order_type_id and (( :$flex$.rlm_customer:null is null ) or ( :$flex$.rlm_customer:null is not null and oh.sold_to_org_id=:$flex$.rlm_customer:null )) order by value,description AR من الطلب D Von Auftrag F Commande - De US From Order ZHS 自订单 7 70 :p_to_order LOV Oracle RLM_ORDER_NUMBER Y select oh.order_number id, oh.order_number value, null description from oe_order_headers oh,oe_order_types_v ot where oh.order_type_id=ot.order_type_id and (( :$flex$.rlm_customer:null is null ) or ( :$flex$.rlm_customer:null is not null and oh.sold_to_org_id=:$flex$.rlm_customer:null )) order by value,description AR إلى الطلب D Bis Auftrag F Commande - A US To Order ZHS 至订单 8 80 :p_from_ship_date DateTime AR من تاريخ المتطلبات D Von Bedarfstermin F Date de besoin - Du US From Requirement Date ZHS 自需求日期 9 90 :p_to_ship_date DateTime AR إلى تاريخ المتطلبات D Bis Bedarfstermin F Date de besoin - Au US To Requirement Date ZHS 至需求日期 10 100 :p_cust_or_inv_item LOV Oracle RLM_CUST_INV_ITEM Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_CUST_INV_ITEM' order by value,description AR العم(ي)ل أو الصنف الم(خ)زني D (K)undenartikel oder (L)agerartikel F Article (c)lient ou (s)tocké US (C)ustomer or (I)nventory Item ZHS 客户或库存物料 11 110 :p_from_item_id LOV Oracle RLM_CUST_INV_ITEM_RANGE Y select item_id id, item_number value, null description from rlm_cust_inv_item_v where (upper(:$flex$.rlm_cust_inv_item)='C' and int_ext_code='EXTERNAL' and :$flex$.rlm_customer:null is null ) or (upper(:$flex$.rlm_cust_inv_item)='C' and int_ext_code='EXTERNAL' and customer_id=:$flex$.rlm_customer:null ) or (upper(:$flex$.rlm_cust_inv_item)='I' and int_ext_code='INTERNAL' and organization_id=:$flex$.rlm_ship_from_org ) order by item_number AR من الصنف D Von Artikel F Article - De US From Item ZHS 自项目 12 120 :p_to_item_id LOV Oracle RLM_CUST_INV_ITEM_RANGE Y select item_id id, item_number value, null description from rlm_cust_inv_item_v where (upper(:$flex$.rlm_cust_inv_item)='C' and int_ext_code='EXTERNAL' and :$flex$.rlm_customer:null is null ) or (upper(:$flex$.rlm_cust_inv_item)='C' and int_ext_code='EXTERNAL' and customer_id=:$flex$.rlm_customer:null ) or (upper(:$flex$.rlm_cust_inv_item)='I' and int_ext_code='INTERNAL' and organization_id=:$flex$.rlm_ship_from_org ) order by item_number AR إلى الصنف D Bis Artikel F Article - A US To Item ZHS 至项目 13 130 :p_req_firm_forecast_both LOV Oracle RLM_FIRM_FORECAST_BOTH Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_FIRM_FORECAST_BOTH' order by value,description Select meaning from fnd_common_lookups where lookup_type = 'RLM_FIRM_FORECAST_BOTH' and lookup_code = 'B' Y AR متطلبات (ث)ابتة وت(ق)ديرية و(ك)لاهما D Anforderungen (F)ix, Pr(o)gnose, (B)eide F Besoins (F)ermes, P(R)évision, Les (D)eux US Requirements (F)irm, F(O)recast, (B)oth ZHS 需求固定(&F)、预测(&O)、两者兼有(&B) 14 140 :p_ship_unship_both LOV Oracle RLM_SHIP_UNSHIP_BOTH Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_SHIP_UNSHIP_BOTH' order by value,description Select meaning from fnd_common_lookups where lookup_type = 'RLM_SHIP_UNSHIP_BOTH' and lookup_code = 'B' Y AR تم الت(س)ليم أو (ل)م يتم التسليم أو (ك)لاهما D (G)eliefert, (N)icht geliefert, (B)eide F (E)xpédié, (N)on expédié ou Les (D)eux US (S)hipped, (U)nshipped or (B)oth ZHS 已发运(&S)、未发运(&U)或两者(&B) 15 150 :p_incl_cancel_lines LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR تضمين السطور الملغاة (ن/ل) D Mit stornierten Zeilen (J/N) F Inclure les lignes annulées (O/N) US Include Canceled Lines (y/n) ZHS 是否包括已取消的行 (y/n) 16 160 :p_sum_date_and_bucket LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR إجمال حسب التاريخ والرزمة (نعم/لا) D Nach Datum und Zeitraum zusammenfassen (J/N) F Synthèse par date et regroupement (O/N) US Summarize by Date and Bucket (y/n) ZHS 按日期和时段汇总 (y/n) 17 170 :p_incl_curr_res_authzns LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR تضمين صلاحيات موارد العملة (نعم/لا) D Mit Genehmigungen aktuelle Ressource (J/N) F Inclure les approbations des ressources actuelles (O/N) US Include Curr Resource Authorizations (y/n) ZHS 是否包括当前资源权限 (y/n)