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）限制的操作单元。 C6E085D4709851A9E05362FB09050512 select t.bill_to_customer_id, t.bill_to_site_use_id, t.ship_to_customer_id, t.ship_to_site_use_id, t.remit_to_address_id, t.receipt_method_id, f.territory_short_name country, hcsu.tax_reference, t.customer_trx_id, t.trx_date, t.trx_number, t.comments, t.purchase_order po, to_date(t.global_attribute1, 'yyyy/mm/dd hh24:mi:ss') tax_date, l.line_number,l.description, nvl( (select nvl(product_fisc_classification, product_category) from zx_lines_det_factors where trx_number = t.trx_number and internal_organization_id = trans.org_id and trx_id = t.customer_trx_id and trx_line_id = l.customer_trx_line_id), nvl( (select mc.segment1 from mtl_categories mc, mtl_item_categories mic where mic.inventory_item_id=msi.inventory_item_id and mic.category_set_id = (select category_set_id from mtl_category_sets where category_set_name = 'STATISTICAL_CODE') and mic.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',trans.org_id)) and mc.category_id=mic.category_id) , m.tax_product_category) ) stat_code, l.uom_code, l.quantity_invoiced, l.unit_selling_price, l.extended_amount, decode(p.tax_rate,0,tax.tax_rate_code,to_char(p.tax_rate)) tax_rate, p.vat_tax_id, p.extended_amount tax, trans.description type, t.invoice_currency_code currency, type.description p_type, l.extended_amount+p.extended_amount total, t.global_attribute3 bank_acc_num, DECODE(:P_ORDER_BY, 'TRX_NUMBER', t.TRX_NUMBER, 'CUSTOMER', hp.PARTY_NAME, 'POSTAL_CODE', hl.POSTAL_CODE, t.TRX_NUMBER) ORDER_BY, JG_JGZZARIN_XMLP_PKG.s_sformula(:INVOICE_TOTAL,t.invoice_currency_code) S_SAY_FORMULA, &trx_date CF_TRX_DATE, &tax_date CF_TAX_DATE, JG_JGZZARIN_XMLP_PKG.cf_1formula() CF_1, JG_JGZZARIN_XMLP_PKG.S_SAY_p S_SAY, JG_JGZZARIN_XMLP_PKG.CP_Ship_Cust_Name_p CP_Ship_Cust_Name, JG_JGZZARIN_XMLP_PKG.CP_Ship_Add_1_p CP_Ship_Add_1, JG_JGZZARIN_XMLP_PKG.CP_Ship_Add_2_p CP_Ship_Add_2, JG_JGZZARIN_XMLP_PKG.CP_Ship_Add_3_p CP_Ship_Add_3, JG_JGZZARIN_XMLP_PKG.CP_Ship_Add_4_p CP_Ship_Add_4, JG_JGZZARIN_XMLP_PKG.CP_Ship_City_p CP_Ship_City, JG_JGZZARIN_XMLP_PKG.CP_Ship_Postal_Code_p CP_Ship_Postal_Code, JG_JGZZARIN_XMLP_PKG.CP_Ship_Country_p CP_Ship_Country, JG_JGZZARIN_XMLP_PKG.CP_Bill_Cust_Name_p CP_Bill_Cust_Name, JG_JGZZARIN_XMLP_PKG.CP_Bill_Add_1_p CP_Bill_Add_1, JG_JGZZARIN_XMLP_PKG.CP_Bill_Add_2_p CP_Bill_Add_2, JG_JGZZARIN_XMLP_PKG.CP_Bill_Add_3_p CP_Bill_Add_3, JG_JGZZARIN_XMLP_PKG.CP_Bill_Add_4_p CP_Bill_Add_4, JG_JGZZARIN_XMLP_PKG.CP_Bill_City_p CP_Bill_City, JG_JGZZARIN_XMLP_PKG.CP_Bill_Postal_Code_p CP_Bill_Postal_Code, JG_JGZZARIN_XMLP_PKG.CP_Bill_Country_p CP_Bill_Country, JG_JGZZARIN_XMLP_PKG.CP_Bill_Tax_Reference_p CP_Bill_Tax_Reference, JG_JGZZARIN_XMLP_PKG.CP_Remit_Cust_p CP_Remit_Cust, JG_JGZZARIN_XMLP_PKG.CP_Remit_Add_1_p CP_Remit_Add_1, JG_JGZZARIN_XMLP_PKG.CP_Remit_Add_2_p CP_Remit_Add_2, JG_JGZZARIN_XMLP_PKG.CP_Remit_Add_3_p CP_Remit_Add_3, JG_JGZZARIN_XMLP_PKG.CP_Remit_Add_4_p CP_Remit_Add_4, JG_JGZZARIN_XMLP_PKG.CP_Remit_City_p CP_Remit_City, JG_JGZZARIN_XMLP_PKG.CP_Remit_Country_p CP_Remit_Country, JG_JGZZARIN_XMLP_PKG.CP_1_p CP_1, JG_JGZZARIN_XMLP_PKG.CP_Remit_Postal_Code_p CP_Remit_Postal_Code from ra_customer_trx_lines_all l, ra_customer_trx_lines_all p, ra_cust_trx_line_gl_dist_all g, hz_cust_acct_sites_all hcas, hz_party_sites hps, hz_locations hl, hz_cust_site_uses_all hcsu, hz_cust_accounts hca, hz_parties hp, ra_customer_trx t, zx_rates_b tax, ra_cust_trx_types_all trans, ra_terms type, ar_memo_lines m, mtl_system_items msi, fnd_territories_vl f where l.customer_trx_line_id = p.link_to_cust_trx_line_id and l.customer_trx_id = t.customer_trx_id and p.customer_trx_id = t.customer_trx_id and g.customer_trx_id = t.customer_trx_id and g.account_class = 'REC' and g.latest_rec_flag = 'Y' and hcsu.site_use_id = t.bill_to_site_use_id and hcas.cust_acct_site_id = hcsu.cust_acct_site_id and hcas.cust_account_id = hca.cust_account_id and hca.party_id = hp.party_id and hcas.party_site_id = hps.party_site_id and hps.location_id = hl.location_id and hl.country = f.territory_code(+) and trans.cust_trx_type_id = t.cust_trx_type_id and t.term_id = type.term_id(+) and p.vat_tax_id = tax.tax_rate_id and l.inventory_item_id = msi.inventory_item_id(+) and l.memo_line_id = m.memo_line_id(+) and decode(:P_BATCH_ID,null,1,:P_BATCH_ID) = decode(:P_BATCH_ID,null,1,t.batch_id) and t.set_of_books_id =:P_SET_OF_BOOKS_ID and t.trx_date between nvl(:P_INVOICE_DATE_LOW,t.trx_date) and nvl(:P_INVOICE_DATE_HIGH,t.trx_date) and t.complete_flag = 'Y' &PRINT_TYPE and t.cust_trx_type_id=decode( :P_DOCUMENT_TYPE,null,t.cust_trx_type_id,:P_DOCUMENT_TYPE) and t.trx_number between decode(:P_INVOICE_NUMBER_LOW,null,:TRX_NUMBER_LOW,:P_INVOICE_NUMBER_LOW) and decode(:P_INVOICE_NUMBER_HIGH,null,:TRX_NUMBER_HIGH,:P_INVOICE_NUMBER_HIGH) and hca.cust_account_id = decode(:P_CUST_ID,null,hca.cust_account_id,:P_CUST_ID) and l.org_id=trans.org_id and p.org_id= trans.org_id and g.org_id=trans.org_id and nvl(msi.organization_id,to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',trans.org_id))) = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',trans.org_id)) Y JG JGZZARIN_XML US JG Regional Invoice Format Program- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Regional Invoice Print Program Application: Regional Localizations Source: Regional Invoice Format Program (XML) - Not Supported: Reserved For Future Use Short Name: JGZZARIN_XML DB package: JG_JGZZARIN_XMLP_PKG BI Publisher &print_type &tax_date &trx_date :comp_number :cp_1 :cp_bill_add_1 :cp_bill_add_2 :cp_bill_add_3 :cp_bill_add_4 :cp_bill_city :cp_bill_country :cp_bill_cust_name :cp_bill_postal_code :cp_bill_tax_reference :cp_remit_add_1 :cp_remit_add_2 :cp_remit_add_3 :cp_remit_add_4 :cp_remit_city :cp_remit_country :cp_remit_cust :cp_remit_postal_code :cp_ship_add_1 :cp_ship_add_2 :cp_ship_add_3 :cp_ship_add_4 :cp_ship_city :cp_ship_country :cp_ship_cust_name :cp_ship_postal_code :func_currency :invoice_total :operating_unit :orderby_acct :p_batch_id :p_conc_request_id :p_country_code :p_cust_id :p_debug_switch :p_document_type :p_invoice_date_high :p_invoice_date_low :p_invoice_number_high :p_invoice_number_low :p_order_by :p_org_id :p_organization_id :p_print_code :p_session_language :p_set_of_books_id :precision :print_type :s_say :select_all :set_of_books_name :struct_num :trx_number_high :trx_number_low :vat_registration_num :where_flex 1 -30 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y US GL_SRS_NULL_NUM Ledger Id 2 -20 :p_dummy1 Char SELECT 'CZ' from dual where JG_ZZ_SHARED_PKg.get_country(MO_GLOBAL.GET_CURRENT_ORG_ID)='CZ' US p_dummy1 p_dummy1 3 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 4 10 :p_order_by LOV Oracle AR_SRS_RAXINV_ORDER_BY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='SRS_RAXINV_ORDER_BY' and lookup_code!='ADJUSTMENT_NUMBER' order by meaning select meaning from ar_lookups where lookup_type='SRS_RAXINV_ORDER_BY' and lookup_code='TRX_NUMBER' Y US Order By Order By 5 20 :p_batch_id LOV Oracle JGZZ_AR_RAXINV_BATCH Y select b.batch_id id, b.name||' ' value, null description from ra_batches b,ra_batch_sources bs where b.batch_source_id=bs.batch_source_id and :$flex$.p_dummy1 is not null order by b.name,bs.name US Batch Batch 6 30 :p_document_type LOV Oracle JEPL_DOC_TYPE Y select cust_trx_type_id id, name value, null description from ra_cust_trx_types where sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate) order by value,description US Document Type Document Type 7 40 :p_print_code LOV Oracle JGZZ_AR_DUPLICATE_INVOICE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and lookup_code= decode(jg_zz_shared_pkg.get_country,'PL',decode(nvl(fnd_profile.value('JGZZ_DUPLICATE_INVOICE'), lookup_code),'Y',lookup_code,'N'),lookup_code) order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = fnd_profile.value('JGZZ_DUPLICATE_INVOICE') Y US DUPLICATE Duplicate 8 50 :p_invoice_number_low LOV Oracle JGZZ_AR_INVOICE_NUMBER Y select trx_number id, trx_number value, null description from ra_customer_trx_all where complete_flag='Y' and cust_trx_type_id=nvl(:$flex$.jepl_doc_type:null,cust_trx_type_id) and set_of_books_id=:$flex$.gl_srs_null_num and ((:$flex$.duplicate='N' and (printing_count is null or printing_count=0)) or (:$flex$.duplicate='Y' and (printing_count is not null or printing_count>0))) and decode(:$flex$.batch:null,null,-1,:$flex$.batch:null)= decode(:$flex$.batch:null,null,-1,batch_id) order by value,description US Invoice Number Low Invoice Number Low 9 60 :p_invoice_number_high LOV Oracle JGZZ_AR_INVOICE_NUMBER Y select trx_number id, trx_number value, null description from ra_customer_trx_all where complete_flag='Y' and cust_trx_type_id=nvl(:$flex$.jepl_doc_type:null,cust_trx_type_id) and set_of_books_id=:$flex$.gl_srs_null_num and ((:$flex$.duplicate='N' and (printing_count is null or printing_count=0)) or (:$flex$.duplicate='Y' and (printing_count is not null or printing_count>0))) and decode(:$flex$.batch:null,null,-1,:$flex$.batch:null)= decode(:$flex$.batch:null,null,-1,batch_id) order by value,description US Invoice Number High Invoice Number High 10 70 :p_invoice_date_low Date US Invoice Date Low Invoice Date Low 11 80 :p_invoice_date_high Date US Invoice Date High Invoice Date High 12 90 :p_cust_id LOV Oracle AR_CUSTOMER_NAME_ID Y Y select cust.cust_account_id id, party.party_name||' ('||cust.account_number||')' value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id and nvl(cust.customer_class_code,'X')= nvl(:$flex$.ar_raxinv_customer_class:null, nvl(cust.customer_class_code,'X')) order by party.party_name,cust.account_number,cust.cust_account_id US Customer Name Customer Name