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_INVOICES_ALL

Line 75: AP_INVOICES_ALL A,

71: SELECT
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

Line 99: AP_INVOICES_ALL A,

95: SELECT
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

Line 123: AP_INVOICES_ALL A,

119: SUM(NVL(B.AMOUNT
120: ,0))
121: INTO V_AMOUNT_DR1
122: FROM
123: AP_INVOICES_ALL A,
124: AP_INVOICE_PAYMENTS_ALL B,
125: AP_CHECKS_ALL C,
126: PO_VENDORS POV,
127: PO_VENDOR_SITES_ALL POVS

Line 147: AP_INVOICES_ALL A,

143: SELECT
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

Line 197: AP_INVOICES_ALL A,

193: MIN(B.EXCHANGE_DATE) EXCHANGE_DATE,
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

Line 227: AP_INVOICES_ALL A,

223: A.EXCHANGE_RATE,
224: B.EXCHANGE_DATE,
225: B.EXCHANGE_RATE_TYPE
226: FROM
227: AP_INVOICES_ALL A,
228: AP_INVOICE_PAYMENTS_ALL B,
229: AP_CHECKS_ALL C,
230: PO_VENDORS POV,
231: PO_VENDOR_SITES_ALL POVS

Line 255: AP_INVOICES_ALL A,

251: B.EXCHANGE_RATE_TYPE,
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

Line 282: AP_INVOICES_ALL B,

278: MIN(A.EXCHANGE_RATE_TYPE) EXCHANGE_RATE_TYPE,
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

Line 375: AP_INVOICES_ALL A,

371: SUM(NVL(XAL.ACCOUNTED_DR
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,