DBA Data[Home] [Help]

APPS.GMF_AR_INVOICE_HEADER_INFO dependencies on AP_TERMS

Line 22: AP_TERMS APT

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
26: NVL(STARTDATE,API.CREATION_DATE) AND