ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D470F751A9E05362FB09050512 select /*MOAC_SQL_CHANGE*/ --added for bug 20359138 ACCT_SITE.CUST_ACCOUNT_ID CUSTOMER_ID, PARTY.PARTY_NAME CUSTOMER_NAME, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER, null Address1, null City, null State, h.transactional_curr_code Currency1, ccr.name Entry_Credit_Check_Rule, nvl(ot.entry_credit_check_rule_id,-1) Entry_Rule_Id, ccr.open_ar_balance_flag Entry_Open_Ar_Flag, ccr.open_ar_days Entry_Open_Ar_Days, ccr.uninvoiced_orders_flag Entry_Uninvoiced_Flag, ccr.orders_on_hold_flag Entry_On_Hold_Flag, nvl(ccr.shipping_interval,-1) Entry_Shipping_Interval, ccr2.name Ship_Credit_Check_Rule, nvl(ot.shipping_credit_check_rule_id ,-1) Ship_Rule_Id, ccr2.open_ar_balance_flag Ship_Open_Ar_Flag, ccr2.open_ar_days Ship_Open_Ar_Days, ccr2.uninvoiced_orders_flag Ship_Uninvoiced_Flag, ccr2.orders_on_hold_flag Ship_On_Hold_Flag, nvl(ccr2.shipping_interval,-1) Ship_Shipping_Interval, ccr3.name Pick_Credit_Check_Rule, nvl(ot.picking_credit_check_rule_id ,-1) Pick_Rule_Id, ccr3.open_ar_balance_flag Pick_Open_Ar_Flag, ccr3.open_ar_days Pick_Open_Ar_Days, ccr3.uninvoiced_orders_flag Pick_Uninvoiced_Flag, ccr3.orders_on_hold_flag Pick_On_Hold_Flag, nvl(ccr3.shipping_interval,-1) Pick_Shipping_Interval, ccr4.name Pack_Credit_Check_Rule, nvl(ot.packing_credit_check_rule_id ,-1) Pack_Rule_Id, ccr4.open_ar_balance_flag Pack_Open_Ar_Flag, ccr4.open_ar_days Pack_Open_Ar_Days, ccr4.uninvoiced_orders_flag Pack_Uninvoiced_Flag, ccr4.orders_on_hold_flag Pack_On_Hold_Flag, nvl(ccr4.shipping_interval,-1) Pack_Shipping_Interval, 0 Site_Use_Id, h.order_number Order_Number, h.ordered_date Order_Date, sum(nvl(l.ordered_quantity,0)* nvl(l.unit_selling_price,0)) Order_Amount, oh.creation_date Date_Placed_On_Hold, round(sysdate - oh.creation_date) Days_On_Hold, ONT_OEXOECCH_XMLP_PKG.c_addressformula(null, null, null) C_ADDRESS, ONT_OEXOECCH_XMLP_PKG.c_data_not_foundformula(PARTY.PARTY_NAME) C_DATA_NOT_FOUND, --ONT_OEXOECCH_XMLP_PKG.c_days_on_hold_cuformula(:S_DAYS_ON_HOLD_CU) C_DAYS_ON_HOLD_CU, ONT_OEXOECCH_XMLP_PKG.c_compute_amountsformula(0, h.transactional_curr_code, ACCT_SITE.CUST_ACCOUNT_ID, ccr.open_ar_days, ccr.open_ar_balance_flag, ccr2.open_ar_days, ccr2.open_ar_balance_flag, ccr.uninvoiced_orders_flag, ccr.orders_on_hold_flag, ccr2.uninvoiced_orders_flag, ccr2.orders_on_hold_flag, nvl ( ccr.shipping_interval , - 1 ), nvl ( ccr2.shipping_interval , - 1 ), nvl ( ot.entry_credit_check_rule_id , - 1 ), nvl ( ot.shipping_credit_check_rule_id , - 1 ), ccr3.open_ar_days, ccr3.open_ar_balance_flag, ccr3.uninvoiced_orders_flag, ccr3.orders_on_hold_flag, nvl ( ccr3.shipping_interval , - 1 ), nvl ( ot.picking_credit_check_rule_id , - 1 ), ccr4.open_ar_days, ccr4.open_ar_balance_flag, ccr4.uninvoiced_orders_flag, ccr4.orders_on_hold_flag, nvl ( ccr4.shipping_interval , - 1 ), nvl ( ot.packing_credit_check_rule_id , - 1 )) C_COMPUTE_AMOUNTS, --ONT_OEXOECCH_XMLP_PKG.c_days_on_hold_crformula(:S_DAYS_ON_HOLD_CR) C_DAYS_ON_HOLD_CR, ONT_OEXOECCH_XMLP_PKG.ORDER_AMOUNT_DSPFORMULA(h.transactional_curr_code,sum(nvl(l.ordered_quantity,0)* nvl(l.unit_selling_price,0))) Order_Amount_Dsp, ONT_OEXOECCH_XMLP_PKG.S_ORDER_AMOUNT_CR_DSPFORMULA(h.transactional_curr_code,sum(nvl(l.ordered_quantity,0)* nvl(l.unit_selling_price,0))), ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_ship_p c_uninv_ord_ship, ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_credit_p c_uninv_ord_credit, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_ship_p c_rec_bal_ship, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_credit_p c_rec_bal_credit, ONT_OEXOECCH_XMLP_PKG.c_tot_order_limit_p c_tot_order_limit, ONT_OEXOECCH_XMLP_PKG.c_order_limit_p c_order_limit, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_pick_p c_rec_bal_pick, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_pack_p c_rec_bal_pack, ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_pick_p c_uninv_ord_pick, ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_pack_p c_uninv_ord_pack from oe_hold_sources_all hs, oe_order_holds_all oh, oe_order_headers_all h, oe_order_lines_all l, oe_order_types_v ot, oe_credit_check_rules ccr, oe_credit_check_rules ccr2, oe_credit_check_rules ccr3, oe_credit_check_rules ccr4, HZ_CUST_SITE_USES_ALL SU, HZ_PARTY_SITES PARTY_SITE, --HZ_LOC_ASSIGNMENTS LOC_ASSIGN, --comment out by bug 20359138 HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT, HZ_CUSTOMER_PROFILES CP where hs.hold_id = 1 and hs.hold_entity_code = 'O' and hs.released_flag = 'N' and oh.hold_source_id = hs.hold_source_id and oh.line_id is null and oh.hold_release_id is null and h.header_id = oh.header_id and h.header_id = l.header_id(+) and h.order_type_id = ot.order_type_id and NVL(h.cancelled_flag, 'N') = 'N' and ot.entry_credit_check_rule_id = ccr.credit_check_rule_id(+) and ot.shipping_credit_check_rule_id = ccr2.credit_check_rule_id(+) and ot.picking_credit_check_rule_id = ccr3.credit_check_rule_id(+) and ot.packing_credit_check_rule_id = ccr4.credit_check_rule_id(+) and h.invoice_to_org_id = su.site_use_id(+) AND SU.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 LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID --comment out for bug 20359138 --AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99) --comment out for bug 20359138 AND ACCT_SITE.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID(+) AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID and h.invoice_to_org_id = cp.site_use_id(+) &lp_customer_name &lp_customer_number &lp_currency_code &lp_order_number &lp_order_type &lp_date_hold_applied GROUP BY ACCT_SITE.CUST_ACCOUNT_ID , PARTY.PARTY_NAME , CUST_ACCT.ACCOUNT_NUMBER , h.transactional_curr_code, ccr.name, nvl(ot.entry_credit_check_rule_id,-1), ccr.open_ar_balance_flag, ccr.open_ar_days, ccr.uninvoiced_orders_flag, ccr.orders_on_hold_flag, nvl(ccr.shipping_interval,-1), ccr2.name, nvl(ot.shipping_credit_check_rule_id,-1), ccr2.open_ar_balance_flag, ccr2.open_ar_days, ccr2.uninvoiced_orders_flag, ccr2.orders_on_hold_flag, nvl(ccr2.shipping_interval,-1), ccr3.name, nvl(ot.picking_credit_check_rule_id,-1), ccr3.open_ar_balance_flag, ccr3.open_ar_days, ccr3.uninvoiced_orders_flag, ccr3.orders_on_hold_flag, nvl(ccr3.shipping_interval,-1), ccr4.name, nvl(ot.packing_credit_check_rule_id,-1), ccr4.open_ar_balance_flag, ccr4.open_ar_days, ccr4.uninvoiced_orders_flag, ccr4.orders_on_hold_flag, nvl(ccr4.shipping_interval,-1), 0, h.order_number, h.ordered_date, oh.creation_date, sysdate - oh.creation_date having sum(nvl(l.ordered_quantity,0)) > 0 UNION select /*MOAC_SQL_CHANGE*/ --add for bug 20359138 ACCT_SITE.CUST_ACCOUNT_ID INVOICE_TO_CUST_ID, PARTY.PARTY_NAME CUSTOMER_NAME, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER, LOC.ADDRESS1 ADDRESS1, LOC.CITY CITY, LOC.STATE STATE, h.transactional_curr_code, ccr.name entry_credit_check_rule, nvl(ot.entry_credit_check_rule_id,-1) entry_rule_id, ccr.open_ar_balance_flag entry_open_ar_flag, ccr.open_ar_days entry_open_ar_days, ccr.uninvoiced_orders_flag entry_uninvoiced_flag, ccr.orders_on_hold_flag entry_on_hold_flag, nvl(ccr.shipping_interval,-1) entry_shipping_interval, ccr2.name ship_credit_check_rule, nvl(ot.shipping_credit_check_rule_id,-1) ship_rule_id, ccr2.open_ar_balance_flag ship_open_ar_flag, ccr2.open_ar_days ship_open_ar_days, ccr2.uninvoiced_orders_flag ship_uninvoiced_flag, ccr2.orders_on_hold_flag ship_on_hold_flag, nvl(ccr2.shipping_interval,-1) ship_shipping_interval, ccr3.name pick_credit_check_rule, nvl(ot.picking_credit_check_rule_id,-1) pick_rule_id, ccr3.open_ar_balance_flag pick_open_ar_flag, ccr3.open_ar_days pick_open_ar_days, ccr3.uninvoiced_orders_flag pick_uninvoiced_flag, ccr3.orders_on_hold_flag pick_on_hold_flag, nvl(ccr3.shipping_interval,-1) pick_shipping_interval, ccr4.name pack_credit_check_rule, nvl(ot.packing_credit_check_rule_id,-1) pack_rule_id, ccr4.open_ar_balance_flag pack_open_ar_flag, ccr4.open_ar_days pack_open_ar_days, ccr4.uninvoiced_orders_flag pack_uninvoiced_flag, ccr4.orders_on_hold_flag pack_on_hold_flag, nvl(ccr4.shipping_interval,-1) pack_shipping_interval, h.invoice_to_org_id site_use_id, h.order_number, h.ordered_date, sum(nvl(l.ordered_quantity,0)* nvl(l.unit_selling_price,0)) order_amount, oh.creation_date, round (sysdate - oh.creation_date) days_on_hold, ONT_OEXOECCH_XMLP_PKG.c_addressformula(null, null, null) C_ADDRESS, ONT_OEXOECCH_XMLP_PKG.c_data_not_foundformula(PARTY.PARTY_NAME) C_DATA_NOT_FOUND, --ONT_OEXOECCH_XMLP_PKG.c_days_on_hold_cuformula(:S_DAYS_ON_HOLD_CU) C_DAYS_ON_HOLD_CU, --Bug 19910063 ONT_OEXOECCH_XMLP_PKG.c_compute_amountsformula(h.invoice_to_org_id, h.transactional_curr_code, ACCT_SITE.CUST_ACCOUNT_ID, ccr.open_ar_days, ccr.open_ar_balance_flag, ccr2.open_ar_days, ccr2.open_ar_balance_flag, ccr.uninvoiced_orders_flag, ccr.orders_on_hold_flag, ccr2.uninvoiced_orders_flag, ccr2.orders_on_hold_flag, nvl ( ccr.shipping_interval , - 1 ), nvl ( ccr2.shipping_interval , - 1 ), nvl ( ot.entry_credit_check_rule_id , - 1 ), nvl ( ot.shipping_credit_check_rule_id , - 1 ), ccr3.open_ar_days, ccr3.open_ar_balance_flag, ccr3.uninvoiced_orders_flag, ccr3.orders_on_hold_flag, nvl ( ccr3.shipping_interval , - 1 ), nvl ( ot.picking_credit_check_rule_id , - 1 ), ccr4.open_ar_days, ccr4.open_ar_balance_flag, ccr4.uninvoiced_orders_flag, ccr4.orders_on_hold_flag, nvl ( ccr4.shipping_interval , - 1 ), nvl ( ot.packing_credit_check_rule_id , - 1 )) C_COMPUTE_AMOUNTS, --ONT_OEXOECCH_XMLP_PKG.c_days_on_hold_crformula(:S_DAYS_ON_HOLD_CR) C_DAYS_ON_HOLD_CR, ONT_OEXOECCH_XMLP_PKG.ORDER_AMOUNT_DSPFORMULA( h.transactional_curr_code,sum(nvl(l.ordered_quantity,0)* nvl(l.unit_selling_price,0))) Order_Amount_Dsp, ONT_OEXOECCH_XMLP_PKG.S_ORDER_AMOUNT_CR_DSPFORMULA(h.transactional_curr_code,sum(nvl(l.ordered_quantity,0)* nvl(l.unit_selling_price,0))), ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_ship_p c_uninv_ord_ship, ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_credit_p c_uninv_ord_credit, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_ship_p c_rec_bal_ship, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_credit_p c_rec_bal_credit, ONT_OEXOECCH_XMLP_PKG.c_tot_order_limit_p c_tot_order_limit, ONT_OEXOECCH_XMLP_PKG.c_order_limit_p c_order_limit, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_pick_p c_rec_bal_pick, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_pack_p c_rec_bal_pack, ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_pick_p c_uninv_ord_pick, ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_pack_p c_uninv_ord_pack from oe_hold_sources_all hs, oe_order_holds_all oh, oe_order_headers_all h, oe_order_lines_all l, oe_order_types_v ot, oe_credit_check_rules ccr, oe_credit_check_rules ccr2, oe_credit_check_rules ccr3, oe_credit_check_rules ccr4, HZ_CUST_SITE_USES_ALL SU, HZ_PARTY_SITES PARTY_SITE, --HZ_LOC_ASSIGNMENTS LOC_ASSIGN, --comment out by bug 20359138 HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT, HZ_CUSTOMER_PROFILES CP, HZ_CUST_PROFILE_AMTS cpa where h.header_id = oh.header_id and oh.line_id is null and oh.hold_release_id is null and oh.hold_source_id = hs.hold_source_id and hs.hold_id = 1 and hs.hold_entity_code = 'O' and hs.released_flag = 'N' and h.header_id = l.header_id(+) and NVL(h.cancelled_flag, 'N') = 'N' and h.order_type_id = ot.order_type_id and ot.entry_credit_check_rule_id = ccr.credit_check_rule_id(+) and ot.shipping_credit_check_rule_id = ccr2.credit_check_rule_id(+) and ot.picking_credit_check_rule_id = ccr3.credit_check_rule_id(+) and ot.packing_credit_check_rule_id = ccr4.credit_check_rule_id(+) and h.invoice_to_org_id = su.site_use_id(+) AND SU.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 LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID --comment out by bug 20359138 -- AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99) --comment out by bug 20359138 AND ACCT_SITE.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID(+) AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID and h.invoice_to_org_id = cp.site_use_id --(+)--comment out by bug 20359138 and cp.credit_checking = 'Y' --and cp.credit_checking(+) = 'Y' --remove(+) by bug 20359138 and cp.CUST_ACCOUNT_PROFILE_ID = cpa.CUST_ACCOUNT_PROFILE_ID and cpa.currency_code = h.transactional_curr_code &lp_customer_name &lp_customer_number &lp_currency_code &lp_order_number &lp_order_type &lp_date_hold_applied GROUP BY ACCT_SITE.CUST_ACCOUNT_ID , PARTY.PARTY_NAME , CUST_ACCT.ACCOUNT_NUMBER , LOC.ADDRESS1 , LOC.CITY , LOC.STATE , h.transactional_curr_code, ccr.name, nvl(ot.entry_credit_check_rule_id,-1), ccr.open_ar_balance_flag, ccr.open_ar_days, ccr.uninvoiced_orders_flag, ccr.orders_on_hold_flag, nvl(ccr.shipping_interval,-1), ccr2.name, nvl(ot.shipping_credit_check_rule_id,-1), ccr2.open_ar_balance_flag, ccr2.open_ar_days, ccr2.uninvoiced_orders_flag, ccr2.orders_on_hold_flag, nvl(ccr2.shipping_interval,-1), ccr3.name, nvl(ot.picking_credit_check_rule_id,-1), ccr3.open_ar_balance_flag, ccr3.open_ar_days, ccr3.uninvoiced_orders_flag, ccr3.orders_on_hold_flag, nvl(ccr3.shipping_interval,-1), ccr4.name, nvl(ot.packing_credit_check_rule_id,-1), ccr4.open_ar_balance_flag, ccr4.open_ar_days, ccr4.uninvoiced_orders_flag, ccr4.orders_on_hold_flag, nvl(ccr4.shipping_interval,-1), h.invoice_to_org_id, h.order_number, h.ordered_date, oh.creation_date, sysdate - oh.creation_date having sum(nvl(l.ordered_quantity,0)) > 0 UNION select /*MOAC_SQL_CHANGE*/ --add for bug 20359138 ACCT_SITE.CUST_ACCOUNT_ID INVOICE_TO_CUST_ID, PARTY.PARTY_NAME CUSTOMER_NAME, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER, null address1, null city, null state, h.transactional_curr_code, ccr.name entry_credit_check_rule, nvl(ot.entry_credit_check_rule_id,-1) entry_rule_id, ccr.open_ar_balance_flag entry_open_ar_flag, ccr.open_ar_days entry_open_ar_days, ccr.uninvoiced_orders_flag entry_uninvoiced_flag, ccr.orders_on_hold_flag entry_on_hold_flag, nvl(ccr.shipping_interval,-1) entry_shipping_interval, ccr2.name ship_credit_check_rule, nvl(ot.shipping_credit_check_rule_id,-1) ship_rule_id, ccr2.open_ar_balance_flag ship_open_ar_flag, ccr2.open_ar_days ship_open_ar_days, ccr2.uninvoiced_orders_flag ship_uninvoiced_flag, ccr2.orders_on_hold_flag ship_on_hold_flag, nvl(ccr2.shipping_interval,-1) ship_shipping_interval, ccr3.name pick_credit_check_rule, nvl(ot.picking_credit_check_rule_id,-1) pick_rule_id, ccr3.open_ar_balance_flag pick_open_ar_flag, ccr3.open_ar_days pick_open_ar_days, ccr3.uninvoiced_orders_flag pick_uninvoiced_flag, ccr3.orders_on_hold_flag pick_on_hold_flag, nvl(ccr3.shipping_interval,-1) pick_shipping_interval, ccr4.name pack_credit_check_rule, nvl(ot.packing_credit_check_rule_id,-1) pack_rule_id, ccr4.open_ar_balance_flag pack_open_ar_flag, ccr4.open_ar_days pack_open_ar_days, ccr4.uninvoiced_orders_flag pack_uninvoiced_flag, ccr4.orders_on_hold_flag pack_on_hold_flag, nvl(ccr4.shipping_interval,-1) pack_shipping_interval, 0 site_use_id, h.order_number, h.ordered_date, sum(nvl(l.ordered_quantity,0)* nvl(l.unit_selling_price,0)) order_amount, oh.creation_date, round (sysdate - oh.creation_date) days_on_hold, ONT_OEXOECCH_XMLP_PKG.c_addressformula(null, null, null) C_ADDRESS, ONT_OEXOECCH_XMLP_PKG.c_data_not_foundformula(PARTY.PARTY_NAME) C_DATA_NOT_FOUND, --ONT_OEXOECCH_XMLP_PKG.c_days_on_hold_cuformula(:S_DAYS_ON_HOLD_CU) C_DAYS_ON_HOLD_CU, ONT_OEXOECCH_XMLP_PKG.c_compute_amountsformula(0, h.transactional_curr_code, ACCT_SITE.CUST_ACCOUNT_ID, ccr.open_ar_days, ccr.open_ar_balance_flag, ccr2.open_ar_days, ccr2.open_ar_balance_flag, ccr.uninvoiced_orders_flag, ccr.orders_on_hold_flag, ccr2.uninvoiced_orders_flag, ccr2.orders_on_hold_flag, nvl ( ccr.shipping_interval , - 1 ), nvl ( ccr2.shipping_interval , - 1 ), nvl ( ot.entry_credit_check_rule_id , - 1 ), nvl ( ot.shipping_credit_check_rule_id , - 1 ), ccr3.open_ar_days, ccr3.open_ar_balance_flag, ccr3.uninvoiced_orders_flag, ccr3.orders_on_hold_flag, nvl ( ccr3.shipping_interval , - 1 ), nvl ( ot.picking_credit_check_rule_id , - 1 ), ccr4.open_ar_days, ccr4.open_ar_balance_flag, ccr4.uninvoiced_orders_flag, ccr4.orders_on_hold_flag, nvl ( ccr4.shipping_interval , - 1 ), nvl ( ot.packing_credit_check_rule_id , - 1 )) C_COMPUTE_AMOUNTS, --ONT_OEXOECCH_XMLP_PKG.c_days_on_hold_crformula(:S_DAYS_ON_HOLD_CR) C_DAYS_ON_HOLD_CR, ONT_OEXOECCH_XMLP_PKG.ORDER_AMOUNT_DSPFORMULA( h.transactional_curr_code,sum(nvl(l.ordered_quantity,0)* nvl(l.unit_selling_price,0))) Order_Amount_Dsp, ONT_OEXOECCH_XMLP_PKG.S_ORDER_AMOUNT_CR_DSPFORMULA(h.transactional_curr_code,sum(nvl(l.ordered_quantity,0)* nvl(l.unit_selling_price,0))), ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_ship_p c_uninv_ord_ship, ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_credit_p c_uninv_ord_credit, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_ship_p c_rec_bal_ship, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_credit_p c_rec_bal_credit, ONT_OEXOECCH_XMLP_PKG.c_tot_order_limit_p c_tot_order_limit, ONT_OEXOECCH_XMLP_PKG.c_order_limit_p c_order_limit, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_pick_p c_rec_bal_pick, ONT_OEXOECCH_XMLP_PKG.c_rec_bal_pack_p c_rec_bal_pack, ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_pick_p c_uninv_ord_pick, ONT_OEXOECCH_XMLP_PKG.c_uninv_ord_pack_p c_uninv_ord_pack from oe_hold_sources_all hs, oe_order_holds_all oh, oe_order_headers_all h, oe_order_lines_all l, oe_order_types_v ot, oe_credit_check_rules ccr, oe_credit_check_rules ccr2, oe_credit_check_rules ccr3, oe_credit_check_rules ccr4, HZ_CUST_SITE_USES_ALL SU, HZ_PARTY_SITES PARTY_SITE, --HZ_LOC_ASSIGNMENTS LOC_ASSIGN, --comment out for bug 20359138 HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT, HZ_CUSTOMER_PROFILES cp, HZ_CUST_PROFILE_AMTS cpa where h.header_id = oh.header_id and NVL(h.cancelled_flag, 'N') = 'N' and oh.line_id is null and oh.hold_release_id is null and oh.hold_source_id = hs.hold_source_id and hs.hold_id = 1 and hs.hold_entity_code = 'O' and hs.released_flag = 'N' and h.header_id = l.header_id(+) and h.order_type_id = ot.order_type_id and ot.entry_credit_check_rule_id = ccr.credit_check_rule_id(+) and ot.shipping_credit_check_rule_id = ccr2.credit_check_rule_id(+) and ot.picking_credit_check_rule_id = ccr3.credit_check_rule_id(+) and ot.packing_credit_check_rule_id = ccr4.credit_check_rule_id(+) and h.invoice_to_org_id = su.site_use_id(+) AND SU.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 LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID --comment out by bug 20359138 --AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99) --comment out by bug 20359138 AND ACCT_SITE.CUST_ACCOUNT_ID = CUST_ACCT.CUST_ACCOUNT_ID(+) AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID and h.invoice_to_org_id = cp.site_use_id --(+) --remove (+) by bug 20359138 and cp.credit_checking = 'Y' --and cp.credit_checking(+) = 'Y' --remove (+) by bug 20359138 and cp.CUST_ACCOUNT_PROFILE_ID = cpa.CUST_ACCOUNT_PROFILE_ID(+) and cpa.currency_code=h.transactional_curr_code --bug 20359138 &lp_customer_name &lp_customer_number &lp_currency_code &lp_order_number &lp_order_type &lp_date_hold_applied GROUP BY ACCT_SITE.CUST_ACCOUNT_ID , PARTY.PARTY_NAME , CUST_ACCT.ACCOUNT_NUMBER , h.transactional_curr_code, ccr.name, nvl(ot.entry_credit_check_rule_id,-1), ccr.open_ar_balance_flag, ccr.open_ar_days, ccr.uninvoiced_orders_flag, ccr.orders_on_hold_flag, nvl(ccr.shipping_interval,-1), ccr2.name, nvl(ot.shipping_credit_check_rule_id,-1), ccr2.open_ar_balance_flag, ccr2.open_ar_days, ccr2.uninvoiced_orders_flag, ccr2.orders_on_hold_flag, nvl(ccr2.shipping_interval,-1), ccr3.name, nvl(ot.picking_credit_check_rule_id,-1), ccr3.open_ar_balance_flag, ccr3.open_ar_days, ccr3.uninvoiced_orders_flag, ccr3.orders_on_hold_flag, nvl(ccr3.shipping_interval,-1), ccr4.name, nvl(ot.packing_credit_check_rule_id,-1), ccr4.open_ar_balance_flag, ccr4.open_ar_days, ccr4.uninvoiced_orders_flag, ccr4.orders_on_hold_flag, nvl(ccr4.shipping_interval,-1), 0, h.order_number, h.ordered_date, oh.creation_date, sysdate - oh.creation_date having sum(nvl(l.ordered_quantity,0)) > 0 order by 2,7,36,8,37 Y ONT OEXOECCH_XML AR ONT تقرير الطلبات الموقوفة بفحص الائتمان Imported from BI Publisher Description: تقرير الطلبات عند إيقاف فحص الائتمان Application: إدارة الطلبات Source: تقرير الطلبات الموقوفة بفحص الائتمان (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG D ONT Aufträge mit Kreditsperre Imported from BI Publisher Description: Aufträge mit Kreditsperre Application: Order Management Source: Aufträge mit Kreditsperre (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG E ONT Informe Pedidos Retenidos por Comprobación de Crédito Imported from BI Publisher Description: Informe Pedidos Retenidos por Comprobación de Crédito Application: Order Management Source: Informe Pedidos Retenidos por Comprobación de Crédito (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG F ONT Etat Commandes bloquées en contrôle du crédit Imported from BI Publisher Description: Etat Commandes bloquées en contrôle du crédit Application: Order Management Source: Etat Commandes bloquées en contrôle du crédit (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG I ONT Rapporto Ordini bloccati per controllo credito Imported from BI Publisher Description: Rapporto Ordini bloccati per controllo credito Application: Order Management Source: Rapporto Ordini bloccati per controllo credito (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG JA ONT 与信チェック保留受注レポート Imported from BI Publisher Description: 与信チェック保留受注レポート Application: Order Management Source: 与信チェック保留受注レポート(XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG KO ONT 신용 확인 보류중인 주문 보고서 Imported from BI Publisher Description: 신용 확인 보류중인 주문 보고서 Application: Order Management Source: 신용 확인 보류중인 주문 보고서(XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG PTB ONT Ordens no Relatório de Retenção de Verificação de Crédito Imported from BI Publisher Description: Ordens no Relatório de Retenção de Checagem de Crédito Application: Gerenciamento de Ordens Source: Ordens no Relatório de Retenção de Verificação de Crédito Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG RU ONT Отчет о заказах, заблокированных для проверки кредита Imported from BI Publisher Description: Отчет о заказах, заблокированных для проверки кредита Application: Управление заказами Source: Отчет о заказах, заблокированных для проверки кредита (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG S ONT Order med kreditkontrollsspärr - rapport Imported from BI Publisher Description: Order med kreditkontrollsspärr - rapport Application: Order Management Source: Order med kreditkontrollsspärr - rapport (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG TR ONT Kredi Kontrolü Bekleyen Siparişler Raporu Imported from BI Publisher Description: Kredi Kontrolu Bekleyen Siparişler Raporu Application: Sipariş Yönetimi(1) Source: Kredi Kontrolü Bekleyen Siparişler Raporu (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG US ONT Orders on Credit Check Hold Imported from BI Publisher Description: Orders on Credit Check Hold Report Application: Order Management Source: Orders on Credit Check Hold Report (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG ZHS ONT 置于信用检查暂挂的订单报表 Imported from BI Publisher Description: 置于信用检查暂挂的订单报表 Application: 订单管理 Source: 置于信用检查暂挂的订单报表 (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG BI Publisher &lp_currency_code &lp_customer_name &lp_customer_number &lp_date_hold_applied &lp_order_number &lp_order_type :c_order_limit :c_rec_bal_credit :c_rec_bal_pack :c_rec_bal_pick :c_rec_bal_ship :c_tot_order_limit :c_uninv_ord_credit :c_uninv_ord_pack :c_uninv_ord_pick :c_uninv_ord_ship :l_order_type :lp_currency_code :lp_customer_name :lp_customer_number :lp_date_hold_applied :lp_order_number :lp_order_type :operating_unit :p_conc_request_id :p_currency_code :p_customer_name :p_customer_number :p_date_hold_applied_high :p_date_hold_applied_low :p_order_number :p_order_type :p_sob_id :p_vat_profile :rp_company_name :rp_curr_profile :rp_data_found :rp_date_hold_applied_range :rp_functional_currency :rp_order :rp_order_amount :rp_pack :rp_pick :rp_report_name :rp_ship :rp_sub_title :rp_total_amount :rp_vat_profile 1 -20 :p_sob_id Number select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) from dual Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão Id do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id ZHS 分类帐标识 分类帐标识 2 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_customer_name LOV Oracle ONT_SRS_CUSTOMER_NAME Y Y select party_name id, party_name value, null description from hz_parties where exists (select null from hz_cust_accounts ha where ha.party_id=hz_parties.party_id) order by party_name AR اسم العميل اسم العميل D Kundenname Kundenname E Nombre de Cliente Nombre de Cliente F Nom du client Nom du client I Nome cliente Nome cliente JA 顧客名 顧客名 KO 고객명 고객명 PTB Nome do Cliente Nome do Cliente RU Имя заказчика Имя заказчика S Kund Kund TR Müşteri Adı Müşteri Adı US Customer Name Customer Name ZHS 客户名称 客户名称 4 20 :p_customer_number LOV Oracle ONT_SRS_CUSTOMER_NUMBER Y select customer_number id, customer_number value, null description from oe_sold_to_orgs_v order by customer_number AR رقم العميل رقم العميل D Kundennummer Kundennummer E Número de Cliente Número de Cliente F Numéro de client Numéro de client I Numero cliente Numero cliente JA 顧客番号 顧客番号 KO 고객 번호 고객 번호 PTB Nº do Cliente Nº do Cliente RU Номер заказчика Номер заказчика S Kundnummer Kundnummer TR Müşteri Numarası Müşteri Numarası US Customer Number Customer Number ZHS 客户编号 客户编号 5 30 :p_order_type LOV Oracle ONT_MOAC_SRS_ORDER_TYPES Y select ot.order_type_id id, ot.name value, null description from oe_order_types_v ot,hr_operating_units ou where ot.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=ot.org_id) order by ot.name AR نوع الطلب نوع الطلب D Auftragsart Auftragsart E Tipo de Pedido Tipo de Pedido F Type de commande Type de commande I Tipo di ordine Tipo di ordine JA 受注タイプ 受注タイプ KO 주문 유형 주문 유형 PTB Tipo de Ordem Tipo de Ordem RU Тип заказа Тип заказа S Ordertyp Ordertyp TR Sipariş Tipi Sipariş Tipi US Order Type Order Type ZHS 订单类型 订单类型 6 40 :p_order_number Number AR رقم الطلب رقم الطلب D Auftragsnummer Auftragsnummer E Número de Pedido Número de Pedido F Numéro de commande Numéro de commande I Numero ordine Numero ordine JA 受注番号 受注番号 KO 주문 번호 주문 번호 PTB Nº da Ordem Nº da Ordem RU Номер заказа Номер заказа S Ordernummer Ordernummer TR Sipariş Numarası Sipariş Numarası US Order Number Order Number ZHS 订单编号 订单编号 7 50 :p_date_hold_applied_low Date AR تاريخ تطبيق الإيقاف (من) تاريخ تطبيق الإيقاف (من) D Von Sperrdatum Von Sperrdatum E Fecha de Aplicación de Retención (De) Fecha de Aplicación de Retención (De) F Date application blocage (Du) Date application blocage (Du) I Data applicazione blocco - Da Data applicazione blocco - Da JA 保留適用日 (自) 保留適用日 (自) KO 보류 적용 일자(부터) 보류 적용 일자(부터) PTB Data de Aplicação da Retenção (De) Data de Aplicação da Retenção (De) RU Дата блокировки с Дата блокировки с S Spärrdatum (från) Spärrdatum (från) TR Durdurma Uygulanan Tarih (İlk) Durdurma Uygulanan Tarih (İlk) US Hold Applied Date (From) Hold Applied Date (From) ZHS 应用暂挂日期（自） 应用暂挂日期（自） 8 60 :p_date_hold_applied_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.hold_applied_date_from)) from sys.dual AR تاريخ تطبيق الإيقاف (إلى) تاريخ تطبيق الإيقاف (إلى) D Bis Sperrdatum Bis Sperrdatum E Fecha de Aplicación de Retención (A) Fecha de Aplicación de Retención (A) F Date application blocage (Au) Date application blocage (Au) I Data applicazione blocco - A Data applicazione blocco - A JA 保留適用日 (至) 保留適用日 (至) KO 보류 적용 일자(까지) 보류 적용 일자(까지) PTB Data de Aplicação da Retenção (Até) Data de Aplicação da Retenção (Até) RU Дата блокировки по Дата блокировки по S Spärrdatum (till) Spärrdatum (till) TR Durdurma Uygulanan Tarih (Son) Durdurma Uygulanan Tarih (Son) US Hold Applied Date (To) Hold Applied Date (To) ZHS 应用暂挂日期（至） 应用暂挂日期（至） 9 70 :p_currency_code LOV Oracle ONT_SRS_CURRENCIES Y select currency_code id, currency_code value, null description from fnd_currencies_vl where enabled_flag='Y' order by currency_code AR رمز العملة رمز العملة D Währungsschlüssel Währungsschlüssel E Código de Divisa Código de Divisa F Code devise Code devise I Codice divisa Codice divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Cód. da Moeda Cód. da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US Currency Code Currency Code ZHS 币种代码 币种代码 :$flex$.hold_applied_date_from Hold Applied Date (From) Y Hold Applied Date (To)