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

Line 76: AP_INVOICE_DISTRIBUTIONS_ALL B,

72: SUM(B.AMOUNT)
73: INTO V_AMOUNT_CR1
74: FROM
75: AP_INVOICES_ALL A,
76: AP_INVOICE_DISTRIBUTIONS_ALL B,
77: PO_VENDORS POV,
78: PO_VENDOR_SITES_ALL POVS
79: WHERE A.INVOICE_ID = B.INVOICE_ID
80: AND POV.VENDOR_ID = A.VENDOR_ID

Line 100: AP_INVOICE_DISTRIBUTIONS_ALL B,

96: SUM(B.AMOUNT)
97: INTO V_AMOUNT_CR2
98: FROM
99: AP_INVOICES_ALL A,
100: AP_INVOICE_DISTRIBUTIONS_ALL B,
101: PO_VENDORS POV,
102: PO_VENDOR_SITES_ALL POVS
103: WHERE A.INVOICE_ID = B.INVOICE_ID
104: AND POV.VENDOR_ID = A.VENDOR_ID

Line 148: AP_INVOICE_DISTRIBUTIONS_ALL B,

144: SUM(B.AMOUNT)
145: INTO V_AMOUNT_DR2
146: FROM
147: AP_INVOICES_ALL A,
148: AP_INVOICE_DISTRIBUTIONS_ALL B,
149: PO_VENDORS POV,
150: PO_VENDOR_SITES_ALL POVS
151: WHERE A.INVOICE_ID = B.INVOICE_ID
152: AND POV.VENDOR_ID = A.VENDOR_ID

Line 198: AP_INVOICE_DISTRIBUTIONS_ALL B,

194: MIN(B.EXCHANGE_RATE_TYPE) EXCHANGE_RATE_TYPE,
195: MIN(B.EXCHANGE_RATE) EXCHANGE_RATE
196: FROM
197: AP_INVOICES_ALL A,
198: AP_INVOICE_DISTRIBUTIONS_ALL B,
199: PO_VENDORS POV,
200: PO_VENDOR_SITES_ALL POVS
201: WHERE A.INVOICE_ID = B.INVOICE_ID
202: AND POV.VENDOR_ID = A.VENDOR_ID

Line 256: AP_INVOICE_DISTRIBUTIONS_ALL B,

252: B.EXCHANGE_RATE,
253: A.INVOICE_CURRENCY_CODE
254: FROM
255: AP_INVOICES_ALL A,
256: AP_INVOICE_DISTRIBUTIONS_ALL B,
257: PO_VENDORS POV,
258: PO_VENDOR_SITES_ALL POVS
259: WHERE A.INVOICE_ID = B.INVOICE_ID
260: AND POV.VENDOR_ID = A.VENDOR_ID

Line 283: AP_INVOICE_DISTRIBUTIONS_ALL A,

279: MIN(A.EXCHANGE_RATE) EXCHANGE_RATE,
280: MIN(A.EXCHANGE_DATE) EXCHANGE_DATE
281: FROM
282: AP_INVOICES_ALL B,
283: AP_INVOICE_DISTRIBUTIONS_ALL A,
284: PO_VENDORS POV,
285: PO_VENDOR_SITES_ALL POVS
286: WHERE A.INVOICE_ID = B.INVOICE_ID
287: AND POV.VENDOR_ID = B.VENDOR_ID

Line 376: AP_INVOICE_DISTRIBUTIONS_ALL B,

372: ,0))
373: INTO V_SUM_EXCH_GAIN_AMT,V_SUM_EXCH_LOSS_AMT
374: FROM
375: AP_INVOICES_ALL A,
376: AP_INVOICE_DISTRIBUTIONS_ALL B,
377: PO_VENDORS POV,
378: PO_VENDOR_SITES_ALL POVS,
379: XLA_AE_LINES XAL,
380: XLA_AE_HEADERS XAH,