DBA Data[Home] [Help]

APPS.AR_INVOICE_UTILS dependencies on GL_USSGL_TRANSACTION_CODES

Line 244: FROM gl_ussgl_transaction_codes gutc

240: FROM ar_trx_header_gt gt
241: WHERE gt.default_ussgl_transaction_code IS NOT NULL
242: AND NOT EXISTS
243: (SELECT 'X'
244: FROM gl_ussgl_transaction_codes gutc
245: WHERE gutc.ussgl_transaction_code = gt.default_ussgl_transaction_code
246: AND gutc.chart_of_accounts_id = arp_global.chart_of_accounts_id
247: AND gt.trx_date
248: BETWEEN NVL(gutc.start_date_active, gt.trx_date)

Line 5789: FROM gl_ussgl_transaction_codes gutc

5785: FROM ar_trx_lines_gt gt
5786: WHERE gt.default_ussgl_transaction_code IS NOT NULL
5787: AND NOT EXISTS
5788: (SELECT 'X'
5789: FROM gl_ussgl_transaction_codes gutc
5790: WHERE gutc.ussgl_transaction_code = gt.default_ussgl_transaction_code
5791: AND gutc.chart_of_accounts_id = arp_global.chart_of_accounts_id
5792: AND gt.trx_date
5793: BETWEEN NVL(gutc.start_date_active, gt.trx_date)