VIEW: APPS.PA_BILLING_INV_PROCESSED_V

Source

View Text - Preformatted

SELECT DI.PROJECT_ID , DI.DRAFT_INVOICE_NUM , DI.AGREEMENT_ID FROM PA_DRAFT_INVOICES DI WHERE DI.PROJECT_ID = NVL(PA_BILLING.GETPROJID,DI.PROJECT_ID) AND DI.REQUEST_ID = NVL(PA_BILLING.GETREQID,DI.REQUEST_ID)

View Text - HTML Formatted

SELECT DI.PROJECT_ID
, DI.DRAFT_INVOICE_NUM
, DI.AGREEMENT_ID
FROM PA_DRAFT_INVOICES DI
WHERE DI.PROJECT_ID = NVL(PA_BILLING.GETPROJID
, DI.PROJECT_ID)
AND DI.REQUEST_ID = NVL(PA_BILLING.GETREQID
, DI.REQUEST_ID)