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）限制的操作单元。 C6E085D4703C51A9E05362FB09050512 SELECT povs.vendor_site_code, api.invoice_type_lookup_code, api.invoice_num, api.invoice_date, apd.description description, apd.dist_code_combination_id ccid, api.invoice_currency_code, api.exchange_rate, Decode(api.invoice_type_lookup_code,'CREDIT', abs(z.amt_val) - abs(nvl(api.discount_amount_taken,0) ) , 0) dr_val, Decode(api.invoice_type_lookup_code,'CREDIT',0, z.amt_val - nvl(api.discount_amount_taken,0) ) cr_val, 0 acct_dr, 0 acct_cr, to_char(api.doc_sequence_value) payment_num, to_char(apd.accounting_date, 'dd-MON-yyyy') pay_accounting_date, NULL check_number, pov.segment1, pov.vendor_name, pov.vendor_type_lookup_code, apd.po_distribution_id, api.exchange_rate_type, api.org_id, api.batch_id, api.exchange_date, api.invoice_id, apd.accounting_date, JA_JAINAPCR_XMLP_PKG.cf_addrformula(api.invoice_num) CF_addr, JA_JAINAPCR_XMLP_PKG.cf_po_noformula(apd.po_distribution_id) CF_po_no, JA_JAINAPCR_XMLP_PKG.cf_orgnformula(apd.po_distribution_id) CF_orgn, JA_JAINAPCR_XMLP_PKG.cf_locnformula(apd.po_distribution_id) CF_locn, JA_JAINAPCR_XMLP_PKG.cf_dr_reformula(api.org_id, api.invoice_type_lookup_code, 0, api.exchange_rate_type, api.invoice_currency_code, api.exchange_date, api.exchange_rate, Decode ( api.invoice_type_lookup_code , 'CREDIT' , abs ( z.amt_val ) - abs ( nvl ( api.discount_amount_taken , 0 ) ) , 0 )) CF_dr_re, JA_JAINAPCR_XMLP_PKG.cf_cr_reformula(api.org_id, api.invoice_type_lookup_code, 0, api.exchange_rate_type, api.invoice_currency_code, api.exchange_date, api.exchange_rate, Decode ( api.invoice_type_lookup_code , 'CREDIT' , 0 , z.amt_val - nvl ( api.discount_amount_taken , 0 ) )) CF_cr_re, JA_JAINAPCR_XMLP_PKG.cf_batchformula(api.batch_id) CF_batch, JA_JAINAPCR_XMLP_PKG.cf_accountformula(apd.dist_code_combination_id) CF_account FROM ap_invoices_all api, ap_invoice_lines_all apil, ap_invoice_distributions_all apd, po_vendors pov, po_vendor_sites_all povs, (SELECT NVL(SUM(apd.amount),0) amt_val, api.invoice_id FROM ap_invoices_all api, ap_invoice_lines_all apil, ap_invoice_distributions_all apd, po_vendors pov, po_vendor_sites_all povs WHERE api.invoice_id = apd.invoice_id and apil.invoice_id = api.invoice_id and apil.line_number = apd.invoice_line_number AND api.vendor_id = pov.vendor_id AND api.vendor_id = NVL(:p_vendor_id, api.vendor_id) AND pov.segment1 = NVL(:p_vendor_no, pov.segment1) AND pov.vendor_type_lookup_code = NVL(:p_vendor_type_lookup_code, pov.vendor_type_lookup_code) AND api.invoice_type_lookup_code <> 'PREPAYMENT' AND (api.org_id = :p_org_id OR api.org_id IS NULL) AND api.vendor_site_id = povs.vendor_site_id AND api.vendor_site_id = NVL(:p_vendor_site_id, api.vendor_site_id) AND apd.accounting_date BETWEEN :p_from_date AND :p_to_date AND apd.match_status_flag='A' AND apil.line_type_lookup_code <> 'PREPAY' GROUP BY api.invoice_id) z WHERE api.invoice_id = z.invoice_id and api.invoice_id = apd.invoice_id and apil.invoice_id = api.invoice_id and apil.line_number = apd.invoice_line_number AND apd.rowid = ( select rowid from ap_invoice_distributions_all where rownum=1 and invoice_id=apd.invoice_id AND accounting_date BETWEEN :p_from_date AND :p_to_date AND match_status_flag='A') AND api.vendor_id = pov.vendor_id AND api.vendor_id = NVL(:p_vendor_id, api.vendor_id) AND pov.segment1 = NVL(:p_vendor_no, pov.segment1) AND pov.vendor_type_lookup_code = NVL(:p_vendor_type_lookup_code, pov.vendor_type_lookup_code) AND api.invoice_type_lookup_code <> 'PREPAYMENT' AND apd.match_status_flag = 'A' AND (api.org_id = :p_org_id OR api.org_id IS NULL) AND api.vendor_site_id = povs.vendor_site_id AND api.vendor_site_id = NVL(:p_vendor_site_id, api.vendor_site_id) AND ( (api.invoice_type_lookup_code <> 'DEBIT') or ( (api.invoice_type_lookup_code = 'DEBIT') and ( not exists (Select '1' from ap_invoice_payments_all app, ap_checks_all apc where app.check_id = apc.check_id and app.invoice_id = api.invoice_id and apc.payment_type_flag = 'R' ) ) ) ) and pov.segment1=:segment2 and povs.vendor_site_code=:vendor_site_code2 UNION all SELECT povs.vendor_site_code, api.invoice_type_lookup_code, api.invoice_num, api.invoice_date, apd.description description, app.accts_pay_code_combination_id ccid, api.payment_currency_code, apc.exchange_rate , Decode(api.invoice_type_lookup_code,'CREDIT',decode(status_lookup_code,'VOIDED',0,0),app.amount) dr_val, Decode(api.invoice_type_lookup_code,'CREDIT',decode(status_lookup_code,'VOIDED',app.amount,abs(app.amount)),0) cr_val, 0 acct_dr, 0 acct_cr, DECODE(api.payment_status_flag, 'Y', to_char(apc.doc_sequence_value), 'P', to_char(apc.doc_sequence_value), to_char(apc.doc_sequence_value), 'N', NULL) payment_num, DECODE(api.payment_status_flag, 'Y', to_char(app.accounting_date, 'dd-MON-yyyy'), 'P', to_char(app.accounting_date, 'dd-MON-yyyy')) pay_accounting_date, DECODE(api.payment_status_flag, 'Y', to_char(apc.check_number), 'P', to_char(apc.check_number)) check_number, pov.segment1, pov.vendor_name, pov.vendor_type_lookup_code, apd.po_distribution_id, apc.exchange_rate_type, api.org_id, api.batch_id, apc.exchange_date, api.invoice_id, app.accounting_date, JA_JAINAPCR_XMLP_PKG.cf_addrformula(api.invoice_num) CF_addr, JA_JAINAPCR_XMLP_PKG.cf_po_noformula(apd.po_distribution_id) CF_po_no, JA_JAINAPCR_XMLP_PKG.cf_orgnformula(apd.po_distribution_id) CF_orgn, JA_JAINAPCR_XMLP_PKG.cf_locnformula(apd.po_distribution_id) CF_locn, JA_JAINAPCR_XMLP_PKG.cf_dr_reformula(api.org_id, api.invoice_type_lookup_code, 0, apc.exchange_rate_type, api.payment_currency_code, apc.exchange_date, apc.exchange_rate, Decode(api.invoice_type_lookup_code,'CREDIT',decode(status_lookup_code,'VOIDED',0,0),app.amount)) CF_dr_re, JA_JAINAPCR_XMLP_PKG.cf_cr_reformula(api.org_id, api.invoice_type_lookup_code, 0, apc.exchange_rate_type, api.payment_currency_code, apc.exchange_date, apc.exchange_rate,Decode(api.invoice_type_lookup_code,'CREDIT',decode(status_lookup_code,'VOIDED',app.amount,abs(app.amount)),0)) CF_cr_re, JA_JAINAPCR_XMLP_PKG.cf_batchformula(api.batch_id) CF_batch, JA_JAINAPCR_XMLP_PKG.cf_accountformula(app.accts_pay_code_combination_id) CF_account FROM ap_invoices_all api, ap_invoice_lines_all apil, ap_invoice_distributions_all apd, po_vendors pov, ap_invoice_payments_all app, ap_checks_all apc, po_vendor_sites_all povs WHERE api.invoice_id = apd.invoice_id and apil.invoice_id = api.invoice_id and apil.line_number = apd.invoice_line_number AND apd.rowid = (select rowid from ap_invoice_distributions_all where rownum=1 and invoice_id=apd.invoice_id and match_status_flag='A') AND api.vendor_id = pov.vendor_id AND app.invoice_id = api.invoice_id AND app.check_id = apc.check_id AND api.vendor_id = NVL(:p_vendor_id, api.vendor_id) AND pov.segment1 = NVL(:p_vendor_no, pov.segment1) AND app.accounting_date BETWEEN :p_from_date AND :p_to_date AND (api.org_id = :p_org_id OR api.org_id IS NULL) AND apc.status_lookup_code IN ('CLEARED', 'NEGOTIABLE','VOIDED','RECONCILED UNACCOUNTED', 'RECONCILED', 'CLEARED BUT UNACCOUNTED') AND apd.match_status_flag='A' AND api.vendor_site_id = povs.vendor_site_id AND api.vendor_site_id = NVL(:p_vendor_site_id, api.vendor_site_id) and pov.segment1=:segment2 and povs.vendor_site_code=:vendor_site_code2 UNION ALL select a.vendor_site_code, 'GAIN/LOSS' invoice_type_lookup_code, api.invoice_num, xah.ACCOUNTING_DATE INVOICE_DATE , null description, a.accts_pay_code_combination_id ccid, xal.currency_code invoice_currency_code, xal.currency_conversion_rate rate , 0 dr_val, 0 cr_val, DECODE(xal.accounting_class_code,'GAIN', accounted_cr,0) acct_dr, DECODE(xal.accounting_class_code,'LOSS',accounted_dr,0) acct_cr, null payment_num, to_char(xah.accounting_date, 'dd-MON-yyyy') pay_accounting_date, null check_number, b.segment1 , b.vendor_name, b.vendor_type_lookup_code, 0 distribution_id, api.exchange_rate_type, api.org_id, api.batch_id, sysdate exchange_date, api.invoice_id, xah.accounting_date, JA_JAINAPCR_XMLP_PKG.cf_addrformula(api.invoice_num) CF_addr, JA_JAINAPCR_XMLP_PKG.cf_po_noformula(0) CF_po_no, JA_JAINAPCR_XMLP_PKG.cf_orgnformula(0) CF_orgn, JA_JAINAPCR_XMLP_PKG.cf_locnformula(0) CF_locn, JA_JAINAPCR_XMLP_PKG.cf_dr_reformula(api.org_id, 'GAIN/LOSS', 0, api.exchange_rate_type, xal.currency_code, sysdate, xal.currency_conversion_rate, 0) CF_dr_re, JA_JAINAPCR_XMLP_PKG.cf_cr_reformula(api.org_id, 'GAIN/LOSS', 0, api.exchange_rate_type, xal.currency_code, sysdate, xal.currency_conversion_rate, 0) CF_cr_re, JA_JAINAPCR_XMLP_PKG.cf_batchformula(api.batch_id) CF_batch, JA_JAINAPCR_XMLP_PKG.cf_accountformula(a.accts_pay_code_combination_id) CF_account from po_vendor_sites_all a, po_vendors b, xla_ae_lines xal, xla_ae_headers xah, xla_transaction_entities xte, ap_invoices_all api where a.vendor_id = b.vendor_id AND a.vendor_id = api.vendor_id AND a.vendor_site_id = api.vendor_site_id AND b.vendor_id = api.vendor_id AND xal.application_id = 200 AND xal.ae_header_id = xah.ae_header_id AND xal.accounting_class_code in ('GAIN','LOSS') AND xah.application_id = 200 AND xah.entity_id = xte.entity_id AND xte.application_id = 200 AND xte.entity_code = 'AP_INVOICES' AND xte.source_id_int_1 = api.invoice_id AND xah.ACCOUNTING_DATE BETWEEN :p_from_date AND :p_to_date AND b.vendor_id = NVL(:p_vendor_id,b.vendor_id) AND (api.org_id = :p_org_id OR api.org_id IS NULL) AND b.segment1 = NVL(:p_vendor_no, b.segment1) AND api.vendor_id = NVL(:p_vendor_id, api.vendor_id) and b.segment1=:segment2 and a.vendor_site_code=:vendor_site_code2 union all select a.vendor_site_code, 'GAIN/LOSS' invoice_type_lookup_code, api.invoice_num, xah.ACCOUNTING_DATE INVOICE_DATE , null description, a.accts_pay_code_combination_id ccid, xal.currency_code invoice_currency_code, xal.currency_conversion_rate rate , 0 dr_val, 0 cr_val, DECODE(xal.accounting_class_code,'GAIN', accounted_cr,0) acct_dr, DECODE(xal.accounting_class_code,'LOSS',accounted_dr,0) acct_cr, null payment_num, to_char(xah.accounting_date, 'dd-MON-yyyy') pay_accounting_date, null check_number, b.segment1 , b.vendor_name, b.vendor_type_lookup_code, apd.po_distribution_id po_distribution_id, api.exchange_rate_type, api.org_id, api.batch_id, sysdate exchange_date, api.invoice_id, xah.accounting_date, JA_JAINAPCR_XMLP_PKG.cf_addrformula(api.invoice_num) CF_addr, JA_JAINAPCR_XMLP_PKG.cf_po_noformula(apd.po_distribution_id) CF_po_no, JA_JAINAPCR_XMLP_PKG.cf_orgnformula(apd.po_distribution_id) CF_orgn, JA_JAINAPCR_XMLP_PKG.cf_locnformula(apd.po_distribution_id) CF_locn, JA_JAINAPCR_XMLP_PKG.cf_dr_reformula(api.org_id,'GAIN/LOSS', 0, api.exchange_rate_type, xal.currency_code, sysdate, xal.currency_conversion_rate, 0) CF_dr_re, JA_JAINAPCR_XMLP_PKG.cf_cr_reformula(api.org_id, 'GAIN/LOSS', 0, api.exchange_rate_type, xal.currency_code, sysdate, xal.currency_conversion_rate, 0) CF_cr_re, JA_JAINAPCR_XMLP_PKG.cf_batchformula(api.batch_id) CF_batch, JA_JAINAPCR_XMLP_PKG.cf_accountformula(a.accts_pay_code_combination_id) CF_account from po_vendor_sites_all a, po_vendors b, xla_ae_lines xal, xla_ae_headers xah, xla_transaction_entities xte, ap_invoices_all api, ap_invoice_lines_all apil, ap_invoice_distributions_all apd where api.invoice_id = apd.invoice_id and apil.invoice_id = api.invoice_id AND apil.line_number = apd.invoice_line_number AND a.vendor_id = b.vendor_id AND a.vendor_id = api.vendor_id AND a.vendor_site_id = api.vendor_site_id AND b.vendor_id = api.vendor_id AND xal.application_id = 200 AND xal.ae_header_id = xah.ae_header_id AND xal.accounting_class_code in ('GAIN','LOSS') AND xah.application_id = 200 AND xah.entity_id = xte.entity_id AND xte.application_id = 200 AND xte.entity_code = 'AP_INVOICES' AND xte.source_id_int_1 = api.invoice_id AND apd.accounting_event_id = xah.event_id AND xah.ACCOUNTING_DATE BETWEEN :p_from_date AND :p_to_date AND b.vendor_id = NVL(:p_vendor_id,b.vendor_id) AND (api.org_id = :p_org_id OR api.org_id IS NULL) AND b.segment1 = NVL(:p_vendor_no, b.segment1) AND api.vendor_id = NVL(:p_vendor_id, api.vendor_id) and b.segment1=:segment2 and a.vendor_site_code=:vendor_site_code2 union all select a.vendor_site_code, 'GAIN/LOSS' invoice_type_lookup_code, api.invoice_num, xah.ACCOUNTING_DATE INVOICE_DATE , null description, a.accts_pay_code_combination_id ccid, xal.currency_code invoice_currency_code, xal.currency_conversion_rate rate , 0 dr_val, 0 cr_val, DECODE(xal.accounting_class_code,'GAIN', accounted_cr,0) acct_dr, DECODE(xal.accounting_class_code,'LOSS',accounted_dr,0) acct_cr, null payment_num, to_char(xah.accounting_date, 'dd-MON-yyyy') pay_accounting_date, to_char(ac.check_number) check_number, b.segment1 , b.vendor_name, b.vendor_type_lookup_code, 0 distribution_id, api.exchange_rate_type, api.org_id, api.batch_id, sysdate exchange_date, api.invoice_id, xah.accounting_date, JA_JAINAPCR_XMLP_PKG.cf_addrformula(api.invoice_num) CF_addr, JA_JAINAPCR_XMLP_PKG.cf_po_noformula(0) CF_po_no, JA_JAINAPCR_XMLP_PKG.cf_orgnformula(0) CF_orgn, JA_JAINAPCR_XMLP_PKG.cf_locnformula(0) CF_locn, JA_JAINAPCR_XMLP_PKG.cf_dr_reformula(api.org_id, 'GAIN/LOSS', 0, api.exchange_rate_type, xal.currency_code, sysdate, xal.currency_conversion_rate, 0) CF_dr_re, JA_JAINAPCR_XMLP_PKG.cf_cr_reformula(api.org_id, 'GAIN/LOSS', 0, api.exchange_rate_type, xal.currency_code, sysdate, xal.currency_conversion_rate, 0) CF_cr_re, JA_JAINAPCR_XMLP_PKG.cf_batchformula(api.batch_id) CF_batch, JA_JAINAPCR_XMLP_PKG.cf_accountformula(a.accts_pay_code_combination_id) CF_account from po_vendor_sites_all a, po_vendors b, xla_ae_lines xal, xla_ae_headers xah, xla_transaction_entities xte, ap_invoices_all api, ap_checks_all ac , ap_invoice_payments_all app where a.vendor_id = b.vendor_id AND a.vendor_id = api.vendor_id AND a.vendor_site_id = api.vendor_site_id AND b.vendor_id = api.vendor_id AND api.invoice_id = app.invoice_id AND app.check_id = ac.check_id AND xal.application_id = 200 AND xal.ae_header_id = xah.ae_header_id AND xal.accounting_class_code in ('GAIN','LOSS') AND xah.application_id = 200 AND xah.entity_id = xte.entity_id AND xte.application_id = 200 AND xte.entity_code = 'AP_PAYMENTS' AND xte.source_id_int_1 = ac.check_id AND xah.event_id = app.accounting_event_id AND ac.status_lookup_code IN ('CLEARED', 'NEGOTIABLE','VOIDED','RECONCILED UNACCOUNTED', 'RECONCILED', 'CLEARED BUT UNACCOUNTED') AND xah.ACCOUNTING_DATE BETWEEN :p_from_date AND :p_to_date AND b.vendor_id = NVL(:p_vendor_id,b.vendor_id) AND (api.org_id = :p_org_id OR api.org_id IS NULL) AND b.segment1 = NVL(:p_vendor_no, b.segment1) AND api.vendor_id = NVL(:p_vendor_id, api.vendor_id) and b.segment1=:segment2 and a.vendor_site_code=:vendor_site_code2 union all select a.vendor_site_code, 'GAIN/LOSS' invoice_type_lookup_code, api.invoice_num, xah. ACCOUNTING_DATE INVOICE_DATE , null description, a.accts_pay_code_combination_id ccid, xal.currency_code invoice_currency_code, xal.currency_conversion_rate rate , 0 dr_val, 0 cr_val, DECODE(xal.accounting_class_code,'GAIN', xal.accounted_cr,0) acct_dr, DECODE(xal.accounting_class_code,'LOSS',xal.accounted_dr,0) acct_cr, null payment_num, to_char(xah.accounting_date, 'dd-MON-yyyy') pay_accounting_date, to_char(ac.check_number) check_number, b.segment1 , b.vendor_name, b.vendor_type_lookup_code, 0 distribution_id, api.exchange_rate_type, api.org_id, api.batch_id, sysdate exchange_date, api.invoice_id, xah.accounting_date, JA_JAINAPCR_XMLP_PKG.cf_addrformula(api.invoice_num) CF_addr, JA_JAINAPCR_XMLP_PKG.cf_po_noformula(0) CF_po_no, JA_JAINAPCR_XMLP_PKG.cf_orgnformula(0) CF_orgn, JA_JAINAPCR_XMLP_PKG.cf_locnformula(0) CF_locn, JA_JAINAPCR_XMLP_PKG.cf_dr_reformula(api.org_id, 'GAIN/LOSS', 0, api.exchange_rate_type, xal.currency_code, sysdate, xal.currency_conversion_rate, 0) CF_dr_re, JA_JAINAPCR_XMLP_PKG.cf_cr_reformula(api.org_id, 'GAIN/LOSS', 0, api.exchange_rate_type, xal.currency_code, sysdate, xal.currency_conversion_rate, 0) CF_cr_re, JA_JAINAPCR_XMLP_PKG.cf_batchformula(api.batch_id) CF_batch, JA_JAINAPCR_XMLP_PKG.cf_accountformula(a.accts_pay_code_combination_id) CF_account from po_vendor_sites_all a, po_vendors b, xla_ae_lines xal, xla_ae_headers xah, xla_transaction_entities xte, ap_invoices_all api, ap_checks_all ac , ap_invoice_payments_all app where a.vendor_id = b.vendor_id AND a.vendor_id = api.vendor_id AND a.vendor_site_id = api.vendor_site_id AND b.vendor_id = api.vendor_id AND api.invoice_id = app.invoice_id AND app.check_id = ac.check_id AND xal.application_id = 200 AND xal.ae_header_id = xah.ae_header_id AND xal.accounting_class_code in ('GAIN','LOSS') and xah.application_id = 200 AND xah.entity_id = xte.entity_id AND xte.application_id = 200 AND xte.entity_code = 'AP_PAYMENTS' AND xte.source_id_int_1 = ac.check_id AND xah.event_id = app.accounting_event_id AND ac.status_lookup_code IN ('CLEARED', 'NEGOTIABLE','VOIDED','RECONCILED UNACCOUNTED', 'RECONCILED', 'CLEARED BUT UNACCOUNTED') AND xah.ACCOUNTING_DATE BETWEEN :p_from_date AND :p_to_date AND b.vendor_id = NVL(:p_vendor_id,b.vendor_id) AND (api.org_id = :p_org_id OR api.org_id IS NULL) AND b.segment1 = NVL(:p_vendor_no, b.segment1) AND api.vendor_id = NVL(:p_vendor_id, api.vendor_id) and b.segment1=:segment2 and a.vendor_site_code=:vendor_site_code2 UNION ALL select DISTINCT a.vendor_site_code, NULL invoice_type_lookup_code, null invoice_num, SYSDATE INVOICE_DATE , null description, a.accts_pay_code_combination_id ccid, null invoice_currency_code, 0 rate , 0 dr_val, 0 cr_val, 0 acct_dr, 0 acct_cr, null payment_num, null pay_accounting_date, null check_number, b.segment1 , b.vendor_name, null, 0 distribution_id, null, a.org_id, 0 batch_id, sysdate exchange_date, 0 invoice_id, sysdate accounting_date, JA_JAINAPCR_XMLP_PKG.cf_addrformula(null) CF_addr, JA_JAINAPCR_XMLP_PKG.cf_po_noformula(0) CF_po_no, JA_JAINAPCR_XMLP_PKG.cf_orgnformula(0) CF_orgn, JA_JAINAPCR_XMLP_PKG.cf_locnformula(0) CF_locn, JA_JAINAPCR_XMLP_PKG.cf_dr_reformula(a.org_id, null, 0, null, null, sysdate, 0, 0) CF_dr_re, JA_JAINAPCR_XMLP_PKG.cf_cr_reformula(a.org_id, null, 0, null, null, sysdate, 0, null) CF_cr_re, JA_JAINAPCR_XMLP_PKG.cf_batchformula(0) CF_batch, JA_JAINAPCR_XMLP_PKG.cf_accountformula(a.accts_pay_code_combination_id) CF_account from po_vendor_sites_all a, po_vendors b, ap_invoices_all c, ap_invoice_lines_all apil, AP_INVOICE_DISTRIBUTIONS_ALL D where apil.invoice_id = c.invoice_id AND apil.line_number = d.invoice_line_number AND a.vendor_id = b.vendor_id and a.vendor_id = c.vendor_id AND A.VENDOR_SITE_ID = C.VENDOR_SITE_ID AND C.INVOICE_ID = D.INVOICE_ID AND D.ACCOUNTING_DATE NOT BETWEEN :p_from_date AND :p_to_date AND C.vendor_id = NVL(:p_vendor_id,c.vendor_id) and A.VENDOR_SITE_ID not in (select VENDOR_SITE_ID from ap_invoices_all A , ap_invoice_distributions_all d where VENDOR_ID = NVL(:p_vendor_id,vendor_id) and A.INVOICE_ID = D.INVOICE_ID AND accounting_date between :p_from_date AND :p_to_date) and b.segment1=:segment2 and a.vendor_site_code=:vendor_site_code2 ORDER BY 17 ASC,18 ASC,16 ASC,21 ASC,1 ASC , 24 , 25 Y JA JAINAPCR_XML US JA India - Creditors Ledger- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Creditors Ledger - India Local Application: Asia/Pacific Localizations Source: India - Creditors Ledger (XML) - Not Supported: Reserved For Future Use Short Name: JAINAPCR_XML DB package: JA_JAINAPCR_XMLP_PKG ZHS JA 印度 - 债权人分类帐- 不支持：已保留供将来使用 Imported from BI Publisher Description: 债权人分类帐 - 印度本地化 Application: 亚太地区本地化 Source: 印度 - 债权人分类帐 (XML) - 不支持：已保留供将来使用 Short Name: JAINAPCR_XML DB package: JA_JAINAPCR_XMLP_PKG BI Publisher :operating_unit :p_chart_of_accts_id :p_conc_request_id :p_from_date :p_from_date_v :p_org_id :p_org_id1 :p_segment2 :p_to_date :p_to_date_v :p_vendor_id :p_vendor_no :p_vendor_site_code2 :p_vendor_site_id :p_vendor_type_lookup_code :segment2 :vendor_site_code2 1 -30 :p_chart_of_accts_id Number SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = fnd_profile.value('GL_SET_OF_BKS_ID') US Chart Of Accts Id ZHS 科目表标识 2 -20 :p_org_id Number select mo_global.get_current_org_id from dual US Org Id ZHS 组织标识 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_vendor_id LOV Oracle JA_IN_VENDOR_ID Y select vendor_id id, vendor_name value, segment1 description from po_vendors pov where vendor_id in (select distinct vendor_id from jai_cmn_vendor_sites) order by value,description US Vendor Name ZHS 供应商名称 5 20 :p_vendor_no LOV Oracle JA_IN_VENDOR_NO Y select a.segment1 id, a.segment1 value, null description from po_vendors a order by a.segment1 US Vendor Number ZHS 供应商编号 6 30 :p_vendor_type_lookup_code LOV Oracle JA_IN_VENDOR_TYPE Y select a.lookup_code id, a.lookup_code value, null description from po_lookup_codes a where a.lookup_type='VENDOR TYPE' order by a.lookup_code US Vendor Type ZHS 供应商类型 7 40 :p_from_date Date Y US From Date ZHS 自日期 8 50 :p_to_date Date Y US To Date ZHS 至日期 9 60 :p_vendor_site_id LOV Oracle JA_IN_VENDOR_SITE_ID Y select p.vendor_site_id id, p.vendor_site_code value, p.vendor_site_id description from po_vendor_sites_all p where p.vendor_site_id in (select vendor_site_id from jai_cmn_vendor_sites b where b.vendor_id=:$flex$.ja_in_vendor_id ) order by p.vendor_site_code US Vendor Site ID Vendor Site ID ZHS 供应商地点标识 供应商地点标识