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）限制的操作单元。 C6E085D470AD51A9E05362FB09050512 select pty.party_name customer_name, pty.jgzz_fiscal_code customer_nit, loc.address1 address1, loc.address2 address2, loc.address3 address3, loc.city || ' '|| loc.province province, ft.territory_short_name country, cr.receipt_number receipt_number, to_char(cr.receipt_date,'DD-MON-YYYY') receipt_date, cr.amount receipt_amount, cr.currency_code currency_code, rm.printed_name payment_mode, DECODE(ct.trx_number, NULL,DECODE(ra.status,'ACC','ACC', 'UNAPP','UNAPP'), ct.trx_number) invoice_number, to_char(ct.trx_date,'DD-MON-YYYY') invoice_date, SUM(NVL(ra.amount_applied,0)) amount_applied, JL_JLCOARCR_XMLP_PKG.cf_invoice_numformula(DECODE ( ct.trx_number , NULL , DECODE ( ra.status , 'ACC' , 'ACC' , 'UNAPP' , 'UNAPP' ) , ct.trx_number )) CF_INVOICE_NUM FROM hz_cust_acct_sites adr, ra_customer_trx ct, hz_cust_accounts cust, hz_parties pty, hz_locations loc, hz_party_sites pst, ar_receipt_methods rm, ar_receivable_applications ra, ar_cash_receipts cr , hz_cust_site_uses su, fnd_territories_vl ft WHERE cr.receipt_date BETWEEN (:p_receipt_date_from) AND (:p_receipt_date_to) AND cr.status IN ('APP','UNAPP','UNID') AND su.site_use_id (+) = cr.customer_site_use_id AND adr.cust_acct_site_id(+) = su.cust_acct_site_id AND adr.party_site_id = pst.party_site_id AND loc.location_id = pst.location_id AND cr.pay_from_customer = cust.cust_account_id(+) AND cust.party_id = pty.party_id AND ra.cash_receipt_id(+) = cr.cash_receipt_id AND ra.status IN( 'APP','ACC','UNAPP') AND ct.customer_trx_id(+) = ra.applied_customer_trx_id AND cr.receipt_method_id = rm.receipt_method_id AND cust.account_number BETWEEN NVL( :p_customer_number_from ,cust.account_number) AND NVL( :p_customer_number_to ,cust.account_number) AND pty.party_name BETWEEN NVL(:p_customer_name_from,pty.party_name) AND NVL( :p_customer_name_to,pty.party_name) AND rm.name = NVL(:p_payment_method,rm.name) AND rm.printed_name= NVL(:p_payment_mode,rm.printed_name) AND pty.jgzz_fiscal_code BETWEEN NVL(:p_third_party_id_from,pty.jgzz_fiscal_code) AND NVL(:p_third_party_id_to,pty.jgzz_fiscal_code) AND cr.receipt_number BETWEEN NVL(:p_receipt_number_from,cr.receipt_number) AND NVL(:p_receipt_number_to,cr.receipt_number) AND ft.territory_code = loc.country GROUP BY cr.receipt_number, pty.party_name, pty.jgzz_fiscal_code, loc.address1, loc.address2, loc.address3, loc.city, loc.province, ft.territory_short_name, cr.receipt_date, cr.amount, cr.currency_code, rm.printed_name, ra.status, ct.trx_number, ct.trx_date ORDER BY cr.receipt_number, ct.trx_number Y JL JLCOARCR_XML US JL Colombian Receivables Cash Receipt Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Colombian Receivables Cash Receipt Report Application: Latin America Localizations Source: Colombian Receivables Cash Receipt Report (XML) - Not Supported: Reserved For Future Use Short Name: JLCOARCR_XML DB package: JL_JLCOARCR_XMLP_PKG BI Publisher :c_func_currency :c_precision :c_report_run_time :c_report_start_date :c_sob_name :c_struct_num :company_name :digit_verif :nit_number :operating_unit :p_conc_request_id :p_customer_name_from :p_customer_name_to :p_customer_number_from :p_customer_number_to :p_legal_entity_id :p_payment_method :p_payment_mode :p_receipt_date_from :p_receipt_date_to :p_receipt_number_from :p_receipt_number_to :p_set_of_books_id :p_third_party_id_from :p_third_party_id_to :vaddress1 :vaddress2 :vaddress3 :vcountry :vlocation_id :vregion :vtown_city 1 -20 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') US GL_SET_OF_BOOKS_ID Ledger Id 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_legal_entity_id LOV Oracle JLCO_GL_LEGAL_ENTITY Y select le.legal_entity_id id, le.name value, le.legal_entity_identifier description from xle_firstparty_information_v le,gl_ledger_le_v lgr where le.legal_entity_id=lgr.legal_entity_id and le.country='CO' and lgr.ledger_id=fnd_profile.value('GL_SET_OF_BKS_ID') order by value,description Y US LEGAL_ENTITY Legal Entity 4 20 :p_receipt_date_from Date Y US Receipt Date From Receipt Date from 5 30 :p_receipt_date_to Date Y US Receipt Date To Receipt Date to 6 40 :p_receipt_number_from LOV Oracle AR_RECEIPT_NUMBER Y Y select cr.receipt_number id, cr.receipt_number value, null description from ar_cash_receipts cr where cr.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts cr2 where cr.receipt_number=cr2.receipt_number) and not exists ( select 'X' from okl_trx_csh_receipt_b oklrct where oklrct.cash_receipt_id=cr.cash_receipt_id and nvl(oklrct.receipt_type,'REG')='FUT' ) order by cr.receipt_number,cr.cash_receipt_id US Receipt Number From Receipt Number from 7 50 :p_receipt_number_to LOV Oracle AR_RECEIPT_NUMBER Y Y select cr.receipt_number id, cr.receipt_number value, null description from ar_cash_receipts cr where cr.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts cr2 where cr.receipt_number=cr2.receipt_number) and not exists ( select 'X' from okl_trx_csh_receipt_b oklrct where oklrct.cash_receipt_id=cr.cash_receipt_id and nvl(oklrct.receipt_type,'REG')='FUT' ) order by cr.receipt_number,cr.cash_receipt_id US Receipt Number To Receipt Number to 8 60 :p_customer_name_from LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name US Customer Name From Customer Name from 9 70 :p_customer_name_to LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name US Customer Name To Customer Name To 10 80 :p_customer_number_from LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number US Customer Number From Customer Number from 11 90 :p_customer_number_to LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number US Customer Number To Customer Number to 12 100 :p_third_party_id_from LOV Oracle JLCO_AR_THIRD_PARTY_ID Y select jgzz_fiscal_code id, jgzz_fiscal_code value, null description from hz_parties pty,hz_cust_accounts cus where cus.global_attribute_category='JL.CO.ARXCUDCI.CUSTOMERS' and cus.global_attribute10 in('LEGAL_ENTITY','FOREIGN_ENTITY','INDIVIDUAL') and cus.party_id=pty.party_id order by jgzz_fiscal_code US Third Party Id From Third Party ID From 13 110 :p_third_party_id_to LOV Oracle JLCO_AR_THIRD_PARTY_ID Y select jgzz_fiscal_code id, jgzz_fiscal_code value, null description from hz_parties pty,hz_cust_accounts cus where cus.global_attribute_category='JL.CO.ARXCUDCI.CUSTOMERS' and cus.global_attribute10 in('LEGAL_ENTITY','FOREIGN_ENTITY','INDIVIDUAL') and cus.party_id=pty.party_id order by jgzz_fiscal_code US Third Party Id To Third Party ID To 14 120 :p_payment_method LOV Oracle AR_SRS_RECEIPT_METHOD Y select name id, name value, null description from ar_receipt_methods where sysdate between start_date and nvl(end_date, sysdate+1) order by value,description US Payment Method Payment Method 15 130 :p_payment_mode LOV Oracle JLCO_AR_PAYMENT_MODE Y Y select printed_name id, printed_name value, null description from ar_receipt_methods order by printed_name US Payment Mode Payment Mode