DBA Data[Home] [Help]

APPS.AP_APXINHIS_XMLP_PKG dependencies on AP_INVOICES

Line 245: AP_INVOICES I2

241: PREPAY_AMT_F
242: FROM
243: AP_INVOICE_DISTRIBUTIONS AID1,
244: AP_INVOICE_DISTRIBUTIONS AID2,
245: AP_INVOICES I2
246: WHERE NVL(AID1.REVERSAL_FLAG
247: ,'N') <> 'Y'
248: AND AID1.PREPAY_DISTRIBUTION_ID is not null
249: AND AID2.INVOICE_DISTRIBUTION_ID = AID1.PREPAY_DISTRIBUTION_ID

Line 268: AP_INVOICES I2

264: T_PREPAY_AMT_F
265: FROM
266: AP_INVOICE_DISTRIBUTIONS AID1,
267: AP_INVOICE_DISTRIBUTIONS AID2,
268: AP_INVOICES I2
269: WHERE NVL(AID1.REVERSAL_FLAG
270: ,'N') <> 'Y'
271: AND AID1.PREPAY_DISTRIBUTION_ID is not null
272: AND AID2.INVOICE_DISTRIBUTION_ID = AID1.PREPAY_DISTRIBUTION_ID

Line 291: AP_INVOICES I2

287: T1_PREPAY_AMT_F
288: FROM
289: AP_INVOICE_DISTRIBUTIONS AID1,
290: AP_INVOICE_DISTRIBUTIONS AID2,
291: AP_INVOICES I2
292: WHERE NVL(AID1.REVERSAL_FLAG
293: ,'N') <> 'Y'
294: AND AID1.PREPAY_DISTRIBUTION_ID is not null
295: AND AID2.INVOICE_DISTRIBUTION_ID = AID1.PREPAY_DISTRIBUTION_ID