DBA Data[Home] [Help]

APPS.GMF_AR_INVOICE_HEADER_INFO dependencies on AP_INVOICES_ALL

Line 21: FROM AP_INVOICES_ALL API,

17: API.INVOICE_CURRENCY_CODE,
18: APT.NAME,
19: NVL(API.INVOICE_AMOUNT,0) + NVL(API.VENDOR_PREPAY_AMOUNT,0) -
20: NVL(API.AMOUNT_PAID,0) - NVL(API.DISCOUNT_AMOUNT_TAKEN,0)
21: FROM AP_INVOICES_ALL API,
22: AP_TERMS APT
23: WHERE API.INVOICE_ID = NVL(INVOICEID,API.INVOICE_ID) AND
24: API.INVOICE_DATE = NVL(INVOICEDATE,API.INVOICE_DATE) AND
25: API.CREATION_DATE BETWEEN