eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on JA_CN_VOUCHER_NUMBER

Line 2291: --Add ja_cn_voucher_number table, voucher number and legal entity

2287: CURSOR journal_number_cur
2288: (ln_je_header_id NUMBER)
2289: IS
2290: --Update by Jianchao Chi, for cnaov2 upgrade 07-JAN-2011
2291: --Add ja_cn_voucher_number table, voucher number and legal entity
2292: --are fetched from ja_cn_voucher_number
2293: --The new one is
2294: SELECT DISTINCT voucher_number journal_number
2295: FROM ja_cn_voucher_number

Line 2292: --are fetched from ja_cn_voucher_number

2288: (ln_je_header_id NUMBER)
2289: IS
2290: --Update by Jianchao Chi, for cnaov2 upgrade 07-JAN-2011
2291: --Add ja_cn_voucher_number table, voucher number and legal entity
2292: --are fetched from ja_cn_voucher_number
2293: --The new one is
2294: SELECT DISTINCT voucher_number journal_number
2295: FROM ja_cn_voucher_number
2296: WHERE je_header_id = ln_je_header_id

Line 2295: FROM ja_cn_voucher_number

2291: --Add ja_cn_voucher_number table, voucher number and legal entity
2292: --are fetched from ja_cn_voucher_number
2293: --The new one is
2294: SELECT DISTINCT voucher_number journal_number
2295: FROM ja_cn_voucher_number
2296: WHERE je_header_id = ln_je_header_id
2297: AND legal_entity_id = pn_legal_entity_id;
2298: --Comment by Jianchao Chi for V2 Upgrade, 07-JAN-2011
2299: --get the journal number from ja_vn_voucher_number