ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4643869E053B46B63588994 select nvl(a.start_date_time,b.start_date_time) start_date, nvl(a.cust_production_seq_num, b.cust_production_seq_num) prod_num, a.header_id new_header_id1, b.header_id old_header_id1, a.line_id, b.line_id line_id1, a.qty_type_code new_code, b.qty_type_code old_code, nvl(a.ship_from_org_id, b.ship_from_org_id) ship_from_org_id, nvl(a.ship_to_org_id, b.ship_to_org_id) ship_to_org_id, nvl(a.bill_to_address_id,b.bill_to_address_id) bill_to_address_id, nvl(a.ship_to_address_id,b.ship_to_address_id) ship_to_address_id, nvl(a.ship_to_name_ext, b.ship_to_name_ext) ship_to_name, nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id) intrmd_ship_to_id, nvl(a.customer_item_id,b.customer_item_id) customer_item_id, nvl(a.inventory_item_id, b.inventory_item_id) inventory_item_id, nvl(a.item_detail_subtype, b.item_detail_subtype) item_detail_subtype, fnd1.meaning detail_subtype, nvl(a.uom_code, b.uom_code) uom_code, nvl(a.cust_po_number, b.cust_po_number) cust_po_number, nvl(a.industry_attribute1,b.industry_attribute1) cust_record_year, a.item_detail_quantity item_detail_quantity1, a.item_detail_type item_detail_type3, fnd2.meaning new_detail_type, b.item_detail_quantity, b.item_detail_type , fnd3.meaning old_detail_type, -- RLM_RLMNETCH_XMLP_PKG.cf_old_cumformula(b.qty_type_code, b.item_detail_quantity, a.qty_type_code,nvl(a.industry_attribute1,b.industry_attribute1),nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id),nvl(a.customer_item_id,b.customer_item_id),nvl(a.ship_from_org_id, b.ship_from_org_id),nvl(a.bill_to_address_id,b.bill_to_address_id),nvl(a.ship_to_address_id,b.ship_to_address_id),nvl(a.inventory_item_id, b.inventory_item_id),nvl(a.cust_po_number, b.cust_po_number),nvl(a.ship_to_org_id, b.ship_to_org_id)) CF_old_cum, -- RLM_RLMNETCH_XMLP_PKG.cf_1formula(a.qty_type_code, a.item_detail_quantity, b.qty_type_code,nvl(a.industry_attribute1,b.industry_attribute1),nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id),nvl(a.customer_item_id,b.customer_item_id),nvl(a.ship_from_org_id, b.ship_from_org_id),nvl(a.bill_to_address_id,b.bill_to_address_id),nvl(a.ship_to_address_id,b.ship_to_address_id),nvl(a.inventory_item_id, b.inventory_item_id),nvl(a.cust_po_number, b.cust_po_number),nvl(a.ship_to_org_id, b.ship_to_org_id)) CF_new_cum, RLM_RLMNETCH_XMLP_PKG.c_actual_old_qtyformula(b.qty_type_code, b.item_detail_quantity,nvl(a.industry_attribute1,b.industry_attribute1),nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id),nvl(a.customer_item_id,b.customer_item_id),nvl(a.ship_from_org_id, b.ship_from_org_id),nvl(a.bill_to_address_id,b.bill_to_address_id),nvl(a.ship_to_address_id,b.ship_to_address_id),nvl(a.inventory_item_id, b.inventory_item_id),nvl(a.cust_po_number, b.cust_po_number),nvl(a.ship_to_org_id, b.ship_to_org_id)) C_actual_old_qty, RLM_RLMNETCH_XMLP_PKG.c_net_changeformula(:C_actual_new_qty, :C_actual_old_qty) C_net_change, RLM_RLMNETCH_XMLP_PKG.cf_percentageformula(:C_sum_old_qty, :CF_old_cum, :C_change_cum) CF_percentage, RLM_RLMNETCH_XMLP_PKG.c_actual_new_qtyformula(a.qty_type_code, a.item_detail_quantity,nvl(a.industry_attribute1,b.industry_attribute1),nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id),nvl(a.customer_item_id,b.customer_item_id),nvl(a.ship_from_org_id, b.ship_from_org_id),nvl(a.bill_to_address_id,b.bill_to_address_id),nvl(a.ship_to_address_id,b.ship_to_address_id),nvl(a.inventory_item_id, b.inventory_item_id),nvl(a.cust_po_number, b.cust_po_number),nvl(a.ship_to_org_id, b.ship_to_org_id)) C_actual_new_qty , RLM_RLMNETCH_XMLP_PKG.c_change_cumformula(:CF_new_cum, :CF_old_cum) C_change_cum from rlm_schedule_lines_all a, rlm_schedule_lines_all b, fnd_lookups fnd1, fnd_lookups fnd2, fnd_lookups fnd3 where (a.org_id = b.org_id and a.org_id = :CP_org_id and a.header_id (+) = :P_new_header_id and b.header_id = :P_old_header_id and a.customer_item_id (+) = b.customer_item_id and a.ship_to_org_id (+) = b.ship_to_org_id and a.ship_from_org_id (+) = b.ship_from_org_id and a.inventory_item_id (+) = b. inventory_item_id and nvl(a.intrmd_ship_to_id,nvl(b.intrmd_ship_to_id,0)) = nvl(b.intrmd_ship_to_id,0) and a.item_detail_subtype (+) = b.item_detail_subtype and a.uom_code (+) = b.uom_code and nvl(a.cust_po_number, nvl(b.cust_po_number,0)) = nvl(b.cust_po_number,0) and a.item_detail_type (+) < :P_ITEM_DETAIL_TYPE and b.item_detail_type < :P_ITEM_DETAIL_TYPE and trunc(a.start_date_time (+) ) = trunc(b.start_date_time) and fnd1.lookup_code = nvl(a.item_detail_subtype, b.item_detail_subtype) and fnd1.lookup_type = :P_RLM_DETAIL_SUBTYPE_CODE and nvl(a.item_detail_type, '0') = fnd2.lookup_code and fnd2.lookup_type = :P_RLM_DETAIL_TYPE_CODE and fnd3.lookup_code = b.item_detail_type and fnd3.lookup_type = :P_RLM_DETAIL_TYPE_CODE) --P_where4 --P_where3 and nvl ( a.customer_item_id , b.customer_item_id )=:customer_item_id1 and nvl ( a.ship_from_org_id , b.ship_from_org_id )=:ship_from_org_id1 and nvl ( a.inventory_item_id , b.inventory_item_id )=:inventory_item_id1 and nvl ( a.ship_to_org_id , b.ship_to_org_id )=:ship_to_org_id1 UNION select nvl(a.start_date_time,b.start_date_time) start_date, nvl(a.cust_production_seq_num, b.cust_production_seq_num) prod_num, a.header_id new_header_id1, b.header_id old_header_id1, a.line_id, b.line_id line_id1, a.qty_type_code new_code, b.qty_type_code old_code, nvl(a.ship_from_org_id, b.ship_from_org_id) ship_from_org_id, nvl(a.ship_to_org_id, b.ship_to_org_id) ship_to_org_id, nvl(a.bill_to_address_id,b.bill_to_address_id) bill_to_address_id, nvl(a.ship_to_address_id,b.ship_to_address_id) ship_to_address_id, nvl(a.ship_to_name_ext, b.ship_to_name_ext) ship_to_name, nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id) intrmd_ship_to_id, nvl(a.customer_item_id,b.customer_item_id) customer_item_id, nvl(a.inventory_item_id, b.inventory_item_id) inventory_item_id, nvl(a.item_detail_subtype, b.item_detail_subtype) item_detail_subtype, fnd1.meaning detail_subtype, nvl(a.uom_code, b.uom_code) uom_code, nvl(a.cust_po_number, b.cust_po_number) cust_po_number, nvl(a.industry_attribute1,b.industry_attribute1) cust_record_year, a.item_detail_quantity item_detail_quantity1, a.item_detail_type item_detail_type3, fnd2.meaning new_detail_type, b.item_detail_quantity, b.item_detail_type , fnd3.meaning old_detail_type, -- RLM_RLMNETCH_XMLP_PKG.cf_old_cumformula(b.qty_type_code, b.item_detail_quantity, a.qty_type_code,nvl(a.industry_attribute1,b.industry_attribute1),nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id),nvl(a.customer_item_id,b.customer_item_id),nvl(a.ship_from_org_id, b.ship_from_org_id),nvl(a.bill_to_address_id,b.bill_to_address_id),nvl(a.ship_to_address_id,b.ship_to_address_id),nvl(a.inventory_item_id, b.inventory_item_id),nvl(a.cust_po_number, b.cust_po_number),nvl(a.ship_to_org_id, b.ship_to_org_id)) CF_old_cum, -- RLM_RLMNETCH_XMLP_PKG.cf_1formula(a.qty_type_code, a.item_detail_quantity, b.qty_type_code,nvl(a.industry_attribute1,b.industry_attribute1),nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id),nvl(a.customer_item_id,b.customer_item_id),nvl(a.ship_from_org_id, b.ship_from_org_id),nvl(a.bill_to_address_id,b.bill_to_address_id),nvl(a.ship_to_address_id,b.ship_to_address_id),nvl(a.inventory_item_id, b.inventory_item_id),nvl(a.cust_po_number, b.cust_po_number),nvl(a.ship_to_org_id, b.ship_to_org_id)) CF_new_cum, RLM_RLMNETCH_XMLP_PKG.c_actual_old_qtyformula(b.qty_type_code, b.item_detail_quantity,nvl(a.industry_attribute1,b.industry_attribute1),nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id),nvl(a.customer_item_id,b.customer_item_id),nvl(a.ship_from_org_id, b.ship_from_org_id),nvl(a.bill_to_address_id,b.bill_to_address_id),nvl(a.ship_to_address_id,b.ship_to_address_id),nvl(a.inventory_item_id, b.inventory_item_id),nvl(a.cust_po_number, b.cust_po_number),nvl(a.ship_to_org_id, b.ship_to_org_id)) C_actual_old_qty, RLM_RLMNETCH_XMLP_PKG.c_net_changeformula(:C_actual_new_qty, :C_actual_old_qty) C_net_change, RLM_RLMNETCH_XMLP_PKG.cf_percentageformula(:C_sum_old_qty, :CF_old_cum, :C_change_cum) CF_percentage, RLM_RLMNETCH_XMLP_PKG.c_actual_new_qtyformula(a.qty_type_code, a.item_detail_quantity,nvl(a.industry_attribute1,b.industry_attribute1),nvl(a.intrmd_ship_to_id,b.intrmd_ship_to_id),nvl(a.customer_item_id,b.customer_item_id),nvl(a.ship_from_org_id, b.ship_from_org_id),nvl(a.bill_to_address_id,b.bill_to_address_id),nvl(a.ship_to_address_id,b.ship_to_address_id),nvl(a.inventory_item_id, b.inventory_item_id),nvl(a.cust_po_number, b.cust_po_number),nvl(a.ship_to_org_id, b.ship_to_org_id)) C_actual_new_qty , RLM_RLMNETCH_XMLP_PKG.c_change_cumformula(:CF_new_cum, :CF_old_cum) C_change_cum from rlm_schedule_lines_all a, rlm_schedule_lines_all b, fnd_lookups fnd1, fnd_lookups fnd2, fnd_lookups fnd3 where (a.org_id = b.org_id and a.org_id = :CP_org_id and a.header_id = :P_new_header_id and b.header_id (+) = :P_old_header_id and b.customer_item_id (+) = a.customer_item_id and b.ship_to_org_id (+) = a.ship_to_org_id and b.ship_from_org_id (+) =a.ship_from_org_id and b.inventory_item_id (+) = a. inventory_item_id and nvl(b.intrmd_ship_to_id, nvl(a.intrmd_ship_to_id,0)) = nvl(a.intrmd_ship_to_id,0) and b.item_detail_subtype (+) = a.item_detail_subtype and b.uom_code (+) = a.uom_code and nvl(b.cust_po_number, nvl(a.cust_po_number, 0)) = nvl(a.cust_po_number,0) and b.item_detail_type (+) < :P_ITEM_DETAIL_TYPE and a.item_detail_type < :P_ITEM_DETAIL_TYPE and trunc(b.start_date_time (+) ) = trunc(a.start_date_time) and fnd1.lookup_code = nvl(b.item_detail_subtype, a.item_detail_subtype) and fnd1.lookup_type = :P_RLM_DETAIL_SUBTYPE_CODE and a.item_detail_type = fnd2.lookup_code and fnd2.lookup_type = :P_RLM_DETAIL_TYPE_CODE and nvl(b.item_detail_type,'0') = fnd3.lookup_code and fnd3.lookup_type = :P_RLM_DETAIL_TYPE_CODE) --P_where5 --P_where3 and nvl ( a.customer_item_id , b.customer_item_id )=:customer_item_id1 and nvl ( a.ship_from_org_id , b.ship_from_org_id )=:ship_from_org_id1 and nvl ( a.inventory_item_id , b.inventory_item_id )=:inventory_item_id1 and nvl ( a.ship_to_org_id , b.ship_to_org_id )=:ship_to_org_id1 ORDER BY 13 ASC, 9 ASC, 10 ASC, 14 ASC, 15 ASC, 16 ASC Y RLM RLMNTCHG_XML AR RLM تقرير صافي التغيير Application: إدارة بيانات الإصدار Source: تقرير صافي التغيير (XML) Short Name: RLMNTCHG_XML DB package: RLM_RLMNETCH_XMLP_PKG D RLM Net Change Application: Release Management Source: Net Change (XML) Short Name: RLMNTCHG_XML DB package: RLM_RLMNETCH_XMLP_PKG F RLM Etat MRP par écarts Application: Release Management Source: Etat MRP par écarts (XML) Short Name: RLMNTCHG_XML DB package: RLM_RLMNETCH_XMLP_PKG US RLM Net Change Application: Release Management Source: Net Change Report (XML) Short Name: RLMNTCHG_XML DB package: RLM_RLMNETCH_XMLP_PKG ZHS RLM 净更改报表 Application: 发放管理 Source: 净更改报表 (XML) Short Name: RLMNTCHG_XML DB package: RLM_RLMNETCH_XMLP_PKG BI Publisher :c_actual_new_qty :c_actual_old_qty :c_change_cum :c_sum_old_qty :cf_new_cum :cf_old_cum :cp_customer_id :cp_default_ou :cp_new_act :cp_new_creation_date :cp_new_cum :cp_new_end :cp_new_start :cp_new_sup_cum :cp_old_act :cp_old_creation_date :cp_old_cum :cp_old_end :cp_old_start :cp_old_sup_cum :cp_org_id :cp_p_auth_quant_flag :cp_p_customer_name :cp_p_new_sch_ref_num :cp_p_nochange_lines_flag :cp_p_old_sch_ref_num :cp_p_other_detail_flag :cp_p_schedule_type :cp_p_ship_from :cp_p_ship_to :cp_prev_value :customer_item_id1 :inventory_item_id1 :operating_unit :p_auth_quant_flag :p_change :p_conc_request_id :p_cust_item_end :p_cust_item_start :p_cust_prodseq_end :p_cust_prodseq_start :p_customer_id :p_item_detail_type :p_lookup_type :p_new_header_id :p_nochange_lines_flag :p_old_header_id :p_org_id :p_other_detail_flag :p_rlm_detail_subtype_code :p_rlm_detail_type_code :p_schedule_type :p_ship_from :p_ship_to :p_title :p_trading_partner :p_where1 :p_where2 :p_where3 :p_where4 :p_where5 :ship_from_org_id1 :ship_to_org_id1 1 10 :p_title Char Net Change Report AR عنوان التقرير D Auswertungstitel F Titre de l'état US Report Title ZHS 报表标题 2 20 :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 Kunde F Client US Customer ZHS 客户 3 30 :p_schedule_type LOV Oracle RLM_SCHEDULE_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='RLM_SCHEDULE_TYPE' order by meaning Y AR نوع الجدول D Planart F Type de programme US Schedule Type ZHS 计划类型 4 40 :p_new_header_id LOV Oracle RLM_SCHEDULE_NUM Y select header_id id, schedule_reference_num value, schedule_purpose description from rlm_schedule_headers where customer_id=:$flex$.rlm_customer and schedule_type=:$flex$.rlm_schedule_type order by value,description Y AR الجدول الجديد D Neuer Plan F Nouveau programme US New Schedule ZHS 新计划 5 50 :p_old_header_id LOV Oracle RLM_SCHEDULE_NUM Y select header_id id, schedule_reference_num value, schedule_purpose description from rlm_schedule_headers where customer_id=:$flex$.rlm_customer and schedule_type=:$flex$.rlm_schedule_type order by value,description Y AR الجدول القديم D Alter Plan F Ancien programme US Old Schedule ZHS 旧计划 6 60 :p_ship_from 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 发货方 7 70 :p_ship_to 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 收货方 8 80 :p_cust_item_start LOV Oracle RLM_CUST_ITEM Y select customer_item_number id, customer_item_number value, customer_item_desc description from mtl_customer_items mci where mci.rowid=(select min(mci1.rowid) from mtl_customer_items mci1 where mci.customer_item_number=mci1.customer_item_number and mci1.customer_id=:$flex$.rlm_customer) order by mci.customer_item_number AR بداية صنف العميل D Von Kundenartikel F Début article client US Customer Item Start ZHS 起始客户项目 9 90 :p_cust_item_end LOV Oracle RLM_CUST_ITEM Y select customer_item_number id, customer_item_number value, customer_item_desc description from mtl_customer_items mci where mci.rowid=(select min(mci1.rowid) from mtl_customer_items mci1 where mci.customer_item_number=mci1.customer_item_number and mci1.customer_id=:$flex$.rlm_customer) order by mci.customer_item_number AR نهاية صنف العميل D Bis Kundenartikel F Fin article client US Customer Item End ZHS 终止客户项目 10 100 :p_cust_prodseq_start Char AR بدء مسلسل الإنتاج D Von Produktionsfolge F Début séquence de production US Prod. Seq. Start ZHS 起始生产序号 11 110 :p_cust_prodseq_end Char AR إنهاء مسلسل الإنتاج D Bis Produktionsfolge F Fin séquence de production US Prod. Seq. End ZHS 终止生产序号 12 120 :p_auth_quant_flag 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 Y AR تضمين الكمية الصالحة؟(ن/ل) D Mit Genehmigungsmenge? (J/N) F Inclure les quantités autorisées ? (O/N) US Include Authorization Quantity?(Y/N) ZHS 是否包括批准数量？(Y/N) 13 130 :p_other_detail_flag 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 Y AR تضمين تفاصيل أخرى؟(ن/ل) D Mit weiteren Daten? (J/N) F Inclure d'autres détails ? (0/N) US Include Other Details?(Y/N) ZHS 是否包括其它详细信息？(Y/N) 14 140 :p_nochange_lines_flag 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 N AR تضمين السطور بدون تغيير؟(ن/ل) D Mit Positionen ohne Änderungen (J/N) F Inclure les lignes sans écart ? (O/N) US Include Lines with no change?(Y/N) ZHS 是否包括无任何更改的行？(Y/N) 15 150 :p_change Number 0 AR تضمين تغيير النسبة أكثر من D Mit prozentualer Änderung mehr als F Inclure les écarts en pourcentage de plus de US Include Percent Change more than ZHS 包括的百分比更改大于 :$flex$.rlm_customer Customer Customer Item End :$flex$.rlm_customer Customer Customer Item Start :$flex$.rlm_customer Customer New Schedule :$flex$.rlm_customer Customer Old Schedule :$flex$.rlm_schedule_type Schedule Type New Schedule :$flex$.rlm_schedule_type Schedule Type Old Schedule