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）限制的操作单元。 C6E085D4703F51A9E05362FB09050512 select aip.accounting_date GL_DATE, 'P' TYPE, api.doc_sequence_value VOUCHER_NO, api.creation_date VOUCHER_DATE, to_char(apc.check_number) CHECK_NUMBER, TO_CHAR(apc.check_date, 'DD-MON-YYYY') CHECK_DATE, apc.vendor_name VENDOR_NAME, api.accts_pay_code_combination_id ACCOUNT_CODE, NVL(api.description,api.invoice_num) DESCRIPTION, TO_CHAR( decode( sign( SUM(aip.amount)), -1, SUM(aip.amount*NVL(aip.exchange_rate,1))*-1, SUM(0) ), 'fm999999999990.00') RECEIPTS, TO_CHAR( decode( sign( SUM(aip.amount)), 1, SUM(aip.amount*NVL(aip.exchange_rate,1)), SUM(0) ), 'fm999999999990.00') PAYMENTS, to_number(SUM(aip.amount*NVL(aip.exchange_rate,1))) PAYMENTS1, aba.bank_account_name BANK_ACCOUNT_NAME, aba.bank_account_num BANK_ACCOUNT_NUM, JA_JAINBBR_XMLP_PKG.cf_closing_balanceformula(:CF_closing_balance, :CF_open_balance, TO_CHAR ( decode ( sign ( SUM ( aip.amount ) ) , - 1 , SUM ( aip.amount * NVL ( aip.exchange_rate , 1 ) ) * - 1 , SUM ( 0 ) ) , 'fm999999999990.00' ), TO_CHAR ( decode ( sign ( SUM ( aip.amount ) ) , 1 , SUM ( aip.amount * NVL ( aip.exchange_rate , 1 ) ) , SUM ( 0 ) ) , 'fm999999999990.00' )) CF_closing_balance, JA_JAINBBR_XMLP_PKG.cf_balanceformula(TO_CHAR ( decode ( sign ( SUM ( aip.amount ) ) , - 1 , SUM ( aip.amount * NVL ( aip.exchange_rate , 1 ) ) * - 1 , SUM ( 0 ) ) , 'fm999999999990.00' ), TO_CHAR ( decode ( sign ( SUM ( aip.amount ) ) , 1 , SUM ( aip.amount * NVL ( aip.exchange_rate , 1 ) ) , SUM ( 0 ) ) , 'fm999999999990.00' )) CF_balance, JA_JAINBBR_XMLP_PKG.cf_account_codeformula(api.accts_pay_code_combination_id) CF_account, JA_JAINBBR_XMLP_PKG.cf_acct_descformula(api.accts_pay_code_combination_id) CF_ACCT_DESC FROM ap_invoice_payments_all aip, ap_invoices_all api, ap_checks_all apc, ap_bank_accounts_all aba WHERE api.invoice_id = aip.invoice_id AND aip.check_id = apc.check_id AND apc.bank_account_id = aba.bank_account_id AND apc.status_lookup_code IN ('NEGOTIABLE', 'CLEARED','VOIDED', 'RECONCILED UNACCOUNTED', 'RECONCILED', 'CLEARED BUT UNACCOUNTED' ) AND aba.bank_account_id = :p_bank_account_id AND aip.INVOICE_PAYMENT_TYPE is null AND aip.accounting_date BETWEEN NVL(:p_start_date,aip.accounting_date) AND NVL(:p_end_date,aip.accounting_date) AND (api.org_id IS NULL OR api.org_id = :p_org_id) GROUP BY aip.accounting_date, api.doc_sequence_value, api.creation_date, apc.check_number, apc.check_date, apc.vendor_name, api.accts_pay_code_combination_id, nvl(api.description,api.invoice_num) , aba.bank_account_name, aba.bank_account_num UNION ALL SELECT apid.accounting_date GL_DATE, 'I' TYPE, api.doc_sequence_value VOUCHER_NO, api.creation_date VOUCHER_DATE, api.invoice_num CHECK_NUMBER, TO_CHAR(api.invoice_date, 'DD-MON-YYYY') CHECK_DATE, POV.vendor_name VENDOR_NAME, api.accts_pay_code_combination_id ACCOUNT_CODE, nvl(api.description,api.invoice_num) DESCRIPTION, to_CHAR(SUM(api.invoice_amount*NVL(api.exchange_rate,1)),'fm999999999990.00') RECEIPTS, TO_CHAR(SUM(0), 'fm999999999990.00') PAYMENTS, to_number(SUM(0)) PAYMENTS1, aba.bank_account_name BANK_ACCOUNT_NAME, aba.bank_account_num BANK_ACCOUNT_NUM, JA_JAINBBR_XMLP_PKG.cf_closing_balanceformula(:CF_closing_balance, :CF_open_balance, to_CHAR(SUM(api.invoice_amount*NVL(api.exchange_rate,1)),'fm999999999990.00'),TO_CHAR(SUM(0), 'fm999999999990.00') ) CF_closing_balance, JA_JAINBBR_XMLP_PKG.cf_balanceformula(to_CHAR(SUM(api.invoice_amount*NVL(api.exchange_rate,1)),'fm999999999990.00'), TO_CHAR(SUM(0), 'fm999999999990.00')) CF_balance, JA_JAINBBR_XMLP_PKG.cf_account_codeformula(api.accts_pay_code_combination_id ) CF_account, JA_JAINBBR_XMLP_PKG.cf_acct_descformula(api.accts_pay_code_combination_id) CF_ACCT_DESC FROM ap_invoice_distributions_all apid, ap_invoice_lines_all apla, ap_invoices_all api, po_vendors POV, ap_bank_accounts_all aba WHERE api.invoice_id=apid.invoice_id AND apla.invoice_id = apid.invoice_id AND apla.line_number = apid.invoice_line_number AND api.vendor_id = pov.vendor_id AND aba.bank_account_id = :p_bank_account_id AND aba.asset_code_combination_id=apid.dist_code_combination_id AND apid.match_status_flag = 'A' AND apid.accounting_date BETWEEN NVL(:p_start_date,apid.accounting_date) AND NVL(:p_end_date,apid.accounting_date) AND (api.org_id IS NULL OR api.org_id = :p_org_id) GROUP BY apid.accounting_date, api.doc_sequence_value, api.creation_date, api.invoice_num, api.invoice_date, pov.vendor_name, api.accts_pay_code_combination_id, nvl(api.description, api.invoice_num ), aba.bank_account_name, aba.bank_account_num UNION ALL SELECT acrh.gl_date GL_DATE, DECODE(acrh.status, 'REVERSED','REV','R') TYPE, acr.doc_sequence_value VOUCHER_NO, acr.creation_date VOUCHER_DATE, NULL CHECK_NUMBER, NULL CHECK_DATE, SUBSTR(hp.PARTY_NAME,1,50) VENDOR_NAME, acrh.account_code_combination_id ACCOUNT_CODE, nvl(acr.comments,acr.receipt_number) DESCRIPTION, TO_CHAR( SUM( DECODE(acrh.status, 'CLEARED',(NVL(acrh.amount,0)*NVL(acrh.exchange_rate,1)), 'REMITTED',(NVL(acrh.amount,0)*NVL(acrh.exchange_rate,1)), 'CONFIRMED',(NVL(acrh.amount,0)*NVL(acrh.exchange_rate,1)))) , 'fm999999999990.00') RECEIPTS, TO_CHAR( SUM( DECODE(acrh.status, 'REVERSED',(acrh.amount*NVL(acrh.exchange_rate,1)))), 'fm999999999990.00') PAYMENTS, to_number(to_char(sum(0))) PAYMENTS1, aba.bank_account_name BANK_ACCOUNT_NAME, aba.bank_account_num BANK_ACCOUNT_NUM, JA_JAINBBR_XMLP_PKG.cf_closing_balanceformula(:CF_closing_balance, :CF_open_balance,TO_CHAR(SUM(DECODE(acrh.status, 'CLEARED',(NVL(acrh.amount,0)*NVL(acrh.exchange_rate,1)),'REMITTED',(NVL(acrh.amount,0)*NVL(acrh.exchange_rate,1)),'CONFIRMED',(NVL(acrh.amount,0)*NVL(acrh.exchange_rate,1)))) , 'fm999999999990.00') , TO_CHAR(SUM(DECODE(acrh.status, 'REVERSED',(acrh.amount*NVL(acrh.exchange_rate,1)))), 'fm999999999990.00')) CF_closing_balance, JA_JAINBBR_XMLP_PKG.cf_balanceformula(TO_CHAR(SUM(DECODE(acrh.status, 'CLEARED',(NVL(acrh.amount,0)*NVL(acrh.exchange_rate,1)),'REMITTED',(NVL(acrh.amount,0)*NVL(acrh.exchange_rate,1)),'CONFIRMED',(NVL(acrh.amount,0)*NVL(acrh.exchange_rate,1)))) , 'fm999999999990.00'),TO_CHAR(SUM(DECODE(acrh.status, 'REVERSED',(acrh.amount*NVL(acrh.exchange_rate,1)))), 'fm999999999990.00') ) CF_balance, JA_JAINBBR_XMLP_PKG.cf_account_codeformula(acrh.account_code_combination_id) CF_account, JA_JAINBBR_XMLP_PKG.cf_acct_descformula(acrh.account_code_combination_id) CF_ACCT_DESC FROM ar_cash_receipt_history_all acrh, ar_cash_receipts_all acr, hz_parties hp, hz_cust_accounts hca, ap_bank_accounts_all aba WHERE acrh.cash_receipt_id = acr.cash_receipt_id AND acr.remittance_bank_account_id = aba.bank_account_id AND hca.party_id = hp.party_id(+) AND acr.pay_from_customer = hca.cust_account_id(+) AND acrh.status IN ('CLEARED', 'REMITTED', 'CONFIRMED','REVERSED') AND aba.bank_account_id = :p_bank_account_id AND acrh.gl_date BETWEEN :p_start_date AND :p_end_date AND (acr.org_id IS NULL OR acr.org_id = :p_org_id) AND ( ( acr.reversal_date IS NOT NULL AND acrh.STATUS = 'REVERSED' ) OR ( acrh.CASH_RECEIPT_HISTORY_ID IN (SELECT MIN(INCRH.CASH_RECEIPT_HISTORY_ID) FROM AR_CASH_RECEIPT_HISTORY_ALL INCRH WHERE INCRH.CASH_RECEIPT_ID = acr.CASH_RECEIPT_ID AND INCRH.STATUS <> 'REVERSED' ) ) ) GROUP BY acrh.gl_date, acrh.status, acr.doc_sequence_value, acr.creation_date, SUBSTR(hp.PARTY_NAME,1,50), acrh.account_code_combination_id, nvl(acr.comments , acr.receipt_number), aba.bank_account_name, aba.bank_account_num UNION ALL SELECT glh.default_effective_date GL_DATE, 'G' TYPE, glh.doc_sequence_value VOUCHER_NO, glh.creation_date VOUCHER_DATE, NULL CHECK_NUMBER, NULL CHECK_DATE, NULL VENDOR_NAME, gll.code_combination_id ACCOUNT_CODE, gll.description DESCRIPTION, DECODE(SUM(accounted_dr), NULL, NULL, TO_CHAR(SUM(accounted_dr), 'fm999999999990.00')) RECEIPTS, DECODE(SUM(accounted_cr), NULL, NULL, TO_CHAR(SUM(accounted_cr), 'fm999999999990.00')) PAYMENTS, to_number(DECODE(SUM(accounted_cr), NULL, NULL, SUM(accounted_cr))) PAYMENTS1, aba.bank_account_name BANK_ACCOUNT_NAME, aba.bank_account_num BANK_ACCOUNT_NUM, JA_JAINBBR_XMLP_PKG.cf_closing_balanceformula(:CF_closing_balance, :CF_open_balance,DECODE(SUM(accounted_dr), NULL, NULL, TO_CHAR(SUM(accounted_dr), 'fm999999999990.00')) , DECODE(SUM(accounted_cr), NULL, NULL, TO_CHAR(SUM(accounted_cr), 'fm999999999990.00'))) CF_closing_balance, JA_JAINBBR_XMLP_PKG.cf_balanceformula(DECODE(SUM(accounted_dr), NULL, NULL, TO_CHAR(SUM(accounted_dr), 'fm999999999990.00')), DECODE(SUM(accounted_cr), NULL, NULL, TO_CHAR(SUM(accounted_cr), 'fm999999999990.00'))) CF_balance, JA_JAINBBR_XMLP_PKG.cf_account_codeformula(gll.code_combination_id ) CF_account, JA_JAINBBR_XMLP_PKG.cf_acct_descformula(gll.code_combination_id) CF_ACCT_DESC FROM gl_je_headers glh, gl_je_lines gll, ap_bank_accounts_all aba WHERE glh.je_header_id = gll.je_header_id AND glh.ledger_id = gll.ledger_id AND gll.ledger_id = :lp_set_of_books_id AND aba.asset_code_combination_id = gll.code_combination_id AND aba.bank_account_id = :p_bank_account_id AND glh.je_source NOT IN ('Payables', 'Receivables') AND glh.default_effective_date BETWEEN :p_start_date AND :p_end_date AND (aba.org_id IS NULL OR aba.org_id = :p_org_id) GROUP BY glh.default_effective_date, gll.code_combination_id, gll.description, aba.bank_account_name, aba.bank_account_num, glh.doc_sequence_value, glh.creation_date ORDER BY 1 JA JAINBBR_XML US JA India - Cash/Bank Book Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: India - Cash/Bank Book Report Application: Asia/Pacific Localizations Source: India - Cash/Bank Book Report (XML) - Not Supported: Reserved For Future Use Short Name: JAINBBR_XML DB package: JA_JAINBBR_XMLP_PKG ZHS JA 印度 - 现金/银行账簿报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 印度 - 现金/银行账簿报表 Application: 亚太地区本地化 Source: 印度 - 现金/银行账簿报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINBBR_XML DB package: JA_JAINBBR_XMLP_PKG BI Publisher :cf_closing_balance :cf_open_balance :lp1_end_date :lp1_start_date :lp_end_date :lp_set_of_books_id :lp_start_date :operating_unit :p_bank_account_id :p_bank_account_name :p_bank_account_num :p_book_type :p_chart_of_accts_id :p_column_value :p_conc_request_id :p_dummy :p_end_date :p_org_id :p_start_date :p_trace_switch 1 -40 :p_org_id Number select mo_global.get_current_org_id from dual US Org ID Operating Unit ID ZHS 组织标识 业务实体标识 2 -30 :p_bank_account_num Char SELECT bank_account_num FROM ap_bank_accounts_all WHERE bank_account_id = :$flex$.account_number Y US Account Number 2 Bank Account Number for which report will be run ZHS 科目编号 2 要为其运行报表的银行账户 3 -20 :p_chart_of_accts_id Number fnd_profile.value('GL_SET_OF_BKS_ID') US Chart of Accounts Ledger ZHS 科目表 分类帐 4 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 5 10 :p_bank_account_name LOV Oracle JA_IN_BANK_NAME Y select a.bank_account_name id, a.bank_account_name value, null description from ap_bank_accounts_all a where a.rowid in (select max(b.rowid) from ap_bank_accounts_all b where b.org_id=fnd_profile.value('ORG_ID') group by b.bank_account_name) order by a.bank_account_name Y US Bank Name Bank Account Name for which report will be run ZHS 银行名称 要为其运行报表的银行账户名称 6 20 :p_bank_account_id LOV Oracle JA_IN_BANK_ACCOUNT_ID Y select a.bank_account_id id, a.bank_account_num value, null description from ap_bank_accounts_all a where a.rowid in (select max(b.rowid) from ap_bank_accounts_all b where b.org_id=fnd_profile.value('ORG_ID') group by b.bank_account_num) and a.bank_account_name=:$flex$.ja_in_bank_name order by value,description Y US Account Number primary key of AP_BANK_ACCOUNTS_ALL table ZHS 科目编号 AP_BANK_ACCOUNTS_ALL 表的主关键字 7 30 :p_book_type LOV Oracle JA_IN_BANK_CASH_OPT Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1021170 order by ffvv.flex_value B Y US Book Type Book Type ZHS 账簿类型 账簿类型 8 40 :p_start_date Date Y US Start Date the starting date for the report ZHS 起始日期 报表起始日期 9 50 :p_end_date Date Y US To Date the end date for the report ZHS 至日期 报表终止日期 :$flex$.account_number Account Number Account Number 2 :$flex$.ja_in_bank_name Bank Name Account Number