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_JAINITCP_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 258: AP_INVOICE_DISTRIBUTIONS_ALL APD1

254: CURSOR FETCH_PREPAYMENT_AMT_CUR IS
255: SELECT
256: SUM(AMOUNT)
257: FROM
258: AP_INVOICE_DISTRIBUTIONS_ALL APD1
259: WHERE INVOICE_ID = INVOICE_ID_V
260: AND LINE_TYPE_LOOKUP_CODE = 'PREPAY'
261: AND PREPAY_DISTRIBUTION_ID IN (
262: SELECT

Line 265: AP_INVOICE_DISTRIBUTIONS_ALL APD2

261: AND PREPAY_DISTRIBUTION_ID IN (
262: SELECT
263: INVOICE_DISTRIBUTION_ID
264: FROM
265: AP_INVOICE_DISTRIBUTIONS_ALL APD2
266: WHERE exists (
267: SELECT
268: 1
269: FROM

Line 304: AP_INVOICE_DISTRIBUTIONS_ALL APD1

300: CURSOR FETCH_PREPAYMENT_AMT_CUR IS
301: SELECT
302: SUM(AMOUNT)
303: FROM
304: AP_INVOICE_DISTRIBUTIONS_ALL APD1
305: WHERE INVOICE_ID = INVOICE_ID_V
306: AND LINE_TYPE_LOOKUP_CODE = 'PREPAY'
307: AND PREPAY_DISTRIBUTION_ID IN (
308: SELECT

Line 311: AP_INVOICE_DISTRIBUTIONS_ALL APD2

307: AND PREPAY_DISTRIBUTION_ID IN (
308: SELECT
309: INVOICE_DISTRIBUTION_ID
310: FROM
311: AP_INVOICE_DISTRIBUTIONS_ALL APD2
312: WHERE exists (
313: SELECT
314: 1
315: FROM