ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE7F79D2E0530100007F1FF2 AR Account Number Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDE8679D2E0530100007F1FF2 AR Customer Name Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDEAF79D2E0530100007F1FF2 AR Period Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',222)||': '||gps.start_date||' - '||gps.end_date description from gl_period_statuses gps where gps.ledger_id= ( select asp.set_of_books_id from ar_system_parameters asp where (:$flex$.ledger is null or asp.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and (:$flex$.operating_unit is null or asp.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and rownum=1 ) and gps.start_date<=sysdate+400 and gps.application_id=222 order by gps.start_date desc AR فترة AR السابقة لدفتر الأستاذ الحالي لتسجيل الدخول D Vergangene AR-Periode des aktuellen Login-Ledgers E Periodo AR pasado del libro de registro actual F Période AR passée du registre de connexion actuel I Periodo AR passato del libro mastro del login corrente JA 現在のログイン帳の過去のAR期間 KO 현재 로그인 원장의 과거 AR 기간 PTB Período AR passado do registro de login atual RU Прошедший период АР текущей регистрационной книги S Senaste AR-perioden för den aktuella inloggningsboken TR Mevcut giriş defterinin geçmiş AR dönemi US Past AR period of the current login ledger ZHS 当前登录分类账的过去AR期 8E2FF36EDE8179D2E0530100007F1FF2 AR TRX Interface Context Y select 'ORDER ENTRY' value, 'Order Entry' description from dual union all select 'PA INVOICES' value, 'Pa Invoices' description from dual union all select 'PA Internal Invoices' value, 'Pa Internal Invoices' description from dual union all select 'PROJECTS INVOICES' value, 'Projects Invoices' description from dual union all select 'OKL_CONTRACTS' value, 'Okl Contracts' description from dual union all select 'OKS CONTRACTS' value, 'Oks Contracts' description from dual union all select 'LOANS' value, 'Loans' description from dual union all select 'CLAIM' value, 'Claim' description from dual union all select 'INTERCOMPANY' value, 'Intercompany' description from dual union all select 'GLOBAL_PROCUREMENT' value, 'Global Procurement' description from dual union all select 'SERVICE' value, 'Service' description from dual union all select 'OTHER' value, 'All other transactions not in above categories' description from dual US 8E2FF36EDE8079D2E0530100007F1FF2 AR Transaction Class Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='INV/CM/ADJ' and flvv.view_application_id=222 and flvv.security_group_id=0 order by flvv.meaning US 8E2FF36EDE9A79D2E0530100007F1FF2 AR Transaction Type Y select rctta.name value, nvl(flvv.meaning,rctta.type)||': '||haouv.name description from hr_all_organization_units_vl haouv, ra_cust_trx_types_all rctta, fnd_lookup_values_vl flvv where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=rctta.org_id and rctta.type=flvv.lookup_code(+) and flvv.lookup_type(+)='INV/CM/ADJ' and flvv.view_application_id(+)=222 and flvv.security_group_id(+)=0 order by rctta.name, haouv.name US 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）限制的操作单元。 B5F889C2A62F0296E0530100007FC863 select x.operating_unit, x.invoice_number, x.trx_number, x.trx_date, x.class, x.type, x.reference, x.credited_invoice, x.account_number, x.party_name, x.currency, x.due_original, x.payment_applied, x.adjustment, x.credit, x.due_remaining, x.dispute_amount, x.state, x.status, x.payment_term, x.invoicing_rule, x.due_date, x.overdue_days, x.ship_date, arm.name receipt_method, replace(initcap(arm.payment_type_code),'_',' ') payment_method, abac.bank_account_num instrument_number, x.payment_server_order_num pson, abbc.bank_name bank_name, abbc.bank_branch_name bank_branch, x.remit_bank_name, x.remit_bank_branch, x.remit_bank_account, x.print_option, x.first_printed_date, x.customer_reference, x.comments, x.bill_to_location, x.bill_to_address, x.taxpayer_id, x.sales_rep, x.category, xxen_util.user_name(x.created_by) created_by, xxen_util.client_time(x.creation_date) creation_date, xxen_util.user_name(x.last_updated_by) last_updated_by, xxen_util.client_time(x.last_update_date) last_update_date from ( select haouv.name operating_unit, acia.cons_billing_number invoice_number, nvl(rcta.trx_number,acra.receipt_number) trx_number, apsa.trx_date, flv1.meaning class, nvl(rctta.name,'Standard') type, nvl(rcta.ct_reference,acra.customer_receipt_reference) reference, decode(apsa.class,'PMT', ( select distinct listagg(nvl2(acia0.cons_billing_number,acia0.cons_billing_number||' - ',null)||rcta0.trx_number,', ') within group (order by rcta0.trx_number) over (partition by araa.cash_receipt_id) applied_trx from ar_receivable_applications_all araa, ra_customer_trx_all rcta0, ar_cons_inv_trx_all acita0, ar_cons_inv_all acia0 where apsa.cash_receipt_id=araa.cash_receipt_id and araa.display='Y' and araa.status='APP' and araa.applied_customer_trx_id=rcta0.customer_trx_id and rcta0.customer_trx_id=acita0.customer_trx_id(+) and acita0.cons_inv_id=acia0.cons_inv_id(+) ), ( select nvl2(acia0.cons_billing_number,acia0.cons_billing_number||' - ',null)||rcta0.trx_number credited_invoice from ra_customer_trx_all rcta0, ar_cons_inv_trx_all acita0, ar_cons_inv_all acia0 where rcta.previous_customer_trx_id=rcta0.customer_trx_id and rcta0.customer_trx_id=acita0.customer_trx_id(+) and acita0.cons_inv_id=acia0.cons_inv_id(+) ) ) credited_invoice, hca.account_number, hp.party_name, hcsua.location bill_to_location, hz_format_pub.format_address (hps.location_id,null,null,' , ') bill_to_address, hp.jgzz_fiscal_code taxpayer_id, apsa.invoice_currency_code currency, apsa.amount_due_original due_original, apsa.amount_applied payment_applied, apsa.amount_adjusted adjustment, apsa.amount_credited credit, apsa.amount_due_remaining due_remaining, case when rctta.accounting_affect_flag='Y' and apsa.amount_in_dispute<>0 then apsa.amount_in_dispute end dispute_amount, nvl(flv3.meaning,decode(apsa.status,'CL','Closed',decode(apsa.amount_due_remaining,apsa.amount_due_original,'Open','Partially Paid'))) state, apsa.status, rtt.name payment_term, decode(rcta.invoicing_rule_id,-3,'Arrears',-2,'Advance') invoicing_rule, apsa.due_date, case when apsa.class in ('INV','DM') and apsa.status='OP' then greatest(trunc(sysdate)-apsa.due_date,0) end overdue_days, rcta.ship_date_actual ship_date, acra.payment_server_order_num, abbr.bank_name remit_bank_name, abbr.bank_branch_name remit_bank_branch, abar.bank_account_num remit_bank_account, flv2.meaning print_option, rcta.printing_original_date first_printed_date, rcta.customer_reference, nvl(rcta.comments,acra.comments) comments, jrret.resource_name sales_rep, decode(apsa.class,'PMT','CASH RECEIPT',nvl(rcta.interface_header_context,rbsa.name)) category, nvl(rcta.created_by,acra.created_by) created_by, nvl(rcta.creation_date,acra.creation_date) creation_date, nvl(rcta.last_updated_by,acra.last_updated_by) last_updated_by, nvl(rcta.last_update_date,acra.last_update_date) last_update_date, nvl(rcta.receipt_method_id,acra.receipt_method_id) receipt_method_id, nvl(rcta.customer_bank_account_id,acra.customer_bank_account_id) customer_bank_account_id from hr_all_organization_units_vl haouv, ar_payment_schedules_all apsa, ra_customer_trx_all rcta, oe_sys_parameters_all ospa, ra_batch_sources_all rbsa, ra_cust_trx_types_all rctta, ra_terms_tl rtt, ar_cons_inv_all acia, hz_cust_accounts hca, hz_parties hp, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, fnd_lookup_values flv1, fnd_lookup_values flv2, jtf_rs_salesreps jrs, jtf_rs_resource_extns_tl jrret, ar_cash_receipts_all acra, ar_cash_receipt_history_all acrha, fnd_lookup_values flv3, ap_bank_accounts_all abar, ap_bank_branches abbr where 1=1 and apsa.payment_schedule_id>0 and apsa.org_id=haouv.organization_id and apsa.customer_trx_id=rcta.customer_trx_id(+) and apsa.org_id=ospa.org_id(+) and ospa.parameter_code(+)='MASTER_ORGANIZATION_ID' and apsa.term_id=rtt.term_id(+) and rtt.language(+)=userenv('LANG') and rcta.cust_trx_type_id=rctta.cust_trx_type_id(+) and rcta.org_id=rctta.org_id(+) and nvl2(rcta.interface_header_context,null,rcta.batch_source_id)=rbsa.batch_source_id(+) and nvl2(rcta.interface_header_context,null,rcta.org_id)=rbsa.org_id(+) and apsa.cons_inv_id=acia.cons_inv_id(+) and apsa.customer_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and apsa.customer_site_use_id=hcsua.site_use_id(+) and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id(+) and hcasa.party_site_id=hps.party_site_id(+) and apsa.class=flv1.lookup_code(+) and rcta.printing_option=flv2.lookup_code(+) and flv1.lookup_type(+)='INV/CM/ADJ' and flv2.lookup_type(+)='INVOICE_PRINT_OPTIONS' and flv1.view_application_id(+)=222 and flv2.view_application_id(+)=222 and flv1.language(+)=userenv('lang') and flv2.language(+)=userenv('lang') and flv1.security_group_id(+)=0 and flv2.security_group_id(+)=0 and case when rcta.primary_salesrep_id>0 then rcta.primary_salesrep_id end=jrs.salesrep_id(+) and case when rcta.primary_salesrep_id>0 then rcta.org_id end=jrs.org_id(+) and jrs.resource_id=jrret.resource_id(+) and jrret.language(+)=userenv('lang') and apsa.cash_receipt_id=acra.cash_receipt_id(+) and apsa.cash_receipt_id=acrha.cash_receipt_id(+) and acrha.current_record_flag(+)='Y' and acrha.status=flv3.lookup_code(+) and flv3.lookup_type(+)='RECEIPT_CREATION_STATUS' and flv3.view_application_id(+)=222 and flv3.language(+)=userenv('lang') and flv3.security_group_id(+)=0 and acra.remittance_bank_account_id = abar.bank_account_id (+) and abar.bank_branch_id = abbr.bank_branch_id (+) ) x, ar_receipt_methods arm, ap_bank_accounts_all abac, ap_bank_branches abbc where x.receipt_method_id=arm.receipt_method_id(+) and x.customer_bank_account_id = abac.bank_account_id (+) and abac.bank_branch_id = abbc.bank_branch_id (+) order by x.operating_unit, x.trx_date desc, x.invoice_number desc, x.trx_number desc Y 49A8B1A8038208ACE0530100007FEB91 :Transaction_Class is not null or :Transaction_Type is not null or :Category is not null or :Period is not null or :Inv_Date_From is not null and :Inv_Date_To is not null or :State is not null or :Status is not null or :Overdue_for_more_than_x_Days is not null or :Customer_Name is not null or :Account_Number is not null or :Invoice_Number is not null or :Transaction_Number is not null or :Print_Date_from is not null and :Print_Date_to is not null or :Operating_Unit is not null US AR Transactions and Payments 11i Detail AR customer billing history including payments, excluding any entered or incomplete transactions. Enginatics 1=1 1 10 1=1 haouv.name=: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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y F Unité d'exploitation US Operating Unit 2 20 1=1 flv1.meaning=:trx_class LOV AR Transaction Class 8E2FF36EDE8079D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='INV/CM/ADJ' and flvv.view_application_id=222 and flvv.security_group_id=0 order by flvv.meaning F Classe de transaction US Transaction Class 3 30 1=1 rctta.name=:trx_type LOV AR Transaction Type 8E2FF36EDE9A79D2E0530100007F1FF2 Y select rctta.name value, nvl(flvv.meaning,rctta.type)||': '||haouv.name description from hr_all_organization_units_vl haouv, ra_cust_trx_types_all rctta, fnd_lookup_values_vl flvv where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and haouv.organization_id=rctta.org_id and rctta.type=flvv.lookup_code(+) and flvv.lookup_type(+)='INV/CM/ADJ' and flvv.view_application_id(+)=222 and flvv.security_group_id(+)=0 order by rctta.name, haouv.name F Type de transaction US Transaction Type 4 40 1=1 rcta.interface_header_context=:category LOV AR TRX Interface Context 8E2FF36EDE8179D2E0530100007F1FF2 Y select 'ORDER ENTRY' value, 'Order Entry' description from dual union all select 'PA INVOICES' value, 'Pa Invoices' description from dual union all select 'PA Internal Invoices' value, 'Pa Internal Invoices' description from dual union all select 'PROJECTS INVOICES' value, 'Projects Invoices' description from dual union all select 'OKL_CONTRACTS' value, 'Okl Contracts' description from dual union all select 'OKS CONTRACTS' value, 'Oks Contracts' description from dual union all select 'LOANS' value, 'Loans' description from dual union all select 'CLAIM' value, 'Claim' description from dual union all select 'INTERCOMPANY' value, 'Intercompany' description from dual union all select 'GLOBAL_PROCUREMENT' value, 'Global Procurement' description from dual union all select 'SERVICE' value, 'Service' description from dual union all select 'OTHER' value, 'All other transactions not in above categories' description from dual F Catégorie Contexte de la ligne d'interface pour les rapports d'EI US Category Interface line context for AR reports 5 1=1 apsa.class='PMT' CASH RECEIPT F Catégorie US Category 6 1=1 nvl(rcta.interface_header_context,'x') not in ( 'ORDER ENTRY', 'PA INVOICES', 'PA Internal Invoices', 'PROJECTS INVOICES', 'OKL_CONTRACTS', 'OKS CONTRACTS', 'LOANS', 'CLAIM', 'INTERCOMPANY', 'GLOBAL_PROCUREMENT', 'SERVICE' ) and apsa.class<>'PMT' OTHER F Catégorie US Category 7 50 1=1 apsa.trx_date>=(select gps.start_date from gl_period_statuses gps where gps.period_name=:period_name and gps.set_of_books_id=(select hou.set_of_books_id from hr_operating_units hou where hou.organization_id=fnd_global.org_id) and gps.application_id=222) and apsa.trx_date<(select gps.end_date+1 from gl_period_statuses gps where gps.period_name=:period_name and gps.set_of_books_id=(select hou.set_of_books_id from hr_operating_units hou where hou.organization_id=fnd_global.org_id) and gps.application_id=222) LOV AR Period 8E2FF36EDEAF79D2E0530100007F1FF2 Y select gps.period_name value, xxen_util.meaning(gps.closing_status,'CLOSING_STATUS',222)||': '||gps.start_date||' - '||gps.end_date description from gl_period_statuses gps where gps.ledger_id= ( select asp.set_of_books_id from ar_system_parameters asp where (:$flex$.ledger is null or asp.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and (:$flex$.operating_unit is null or asp.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and rownum=1 ) and gps.start_date<=sysdate+400 and gps.application_id=222 order by gps.start_date desc F Période US Period 8 60 1=1 apsa.trx_date>=:trx_date_from Date F Date de l'Inv. US Inv. Date From 9 70 1=1 apsa.trx_date<:trx_date_to+1 Date last_day(:$flex$.inv_date_from) F Date de l'inv. US Inv. Date To 10 80 1=1 flv3.meaning=substr(:state,10) LOV custom Y select 'Payment: '||flv.meaning value, flv.description from fnd_lookup_values flv where flv.lookup_type='RECEIPT_CREATION_STATUS' and flv.view_application_id=222 and flv.language=userenv('lang') and flv.security_group_id=0 union all select 'Transaction: Closed' value, 'zero remaining balance' description from dual union all select 'Transaction: Open' value, 'original amount still open' description from dual union all select 'Transaction: Partially Paid' value, 'partial payment applications' description from dual order by 2,1 Payment: % F État US State 11 1=1 apsa.status=upper(substr(x.value,14,2)) Transaction: % F État US State 12 1=1 apsa.status='OP' and apsa.amount_due_original<>apsa.amount_due_remaining Transaction: Partially Paid F État US State 13 90 1=1 apsa.status=:status LOV custom Y select 'OP' value, 'Open' description from dual union all select 'CL' value, 'Closed' description from dual F Statut US Status 14 100 1=1 apsa.class in ('INV','DM') and apsa.status='OP' and greatest(trunc(sysdate)-apsa.due_date,0)>:overdue_days Number F En retard de plus de x jours US Overdue for more than x Days 15 110 1=1 upper(hp.party_name) like upper(:customer_name) LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Nom du client US Customer Name 16 120 1=1 hca.account_number=:account_number LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Numéro de compte US Account Number 17 130 1=1 acia.cons_billing_number=:cons_billing_number Char F Numéro de facture US Invoice Number 18 140 1=1 apsa.trx_number=:trx_number Char F Numéro de transaction US Transaction Number 19 150 1=1 rcta.printing_original_date>=:print_date_from DateTime F Imprimer Date de US Print Date from 20 160 1=1 rcta.printing_original_date<=:print_date_to DateTime :$flex$.print_date_from F Imprimer Date à US Print Date to :$flex$.inv_date_from Inv. Date From Y Inv. Date To :$flex$.operating_unit Operating Unit Account Number :$flex$.operating_unit Operating Unit Customer Name :$flex$.operating_unit Operating Unit Period :$flex$.operating_unit Operating Unit Transaction Type :$flex$.print_date_from Print Date from Y Print Date to