[Home] [Help]
View: PA_BILLING_INV_PROCESSED_V
Product: | PA - Projects |
Description: | PA_BILLING_INV_PROCESSED_V returns information about invoices processed in the current run, for use with billing extensions. |
Implementation/DBA Data: |
APPS.PA_BILLING_INV_PROCESSED_V
|
View Text
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)
Columns
Name |
PROJECT_ID |
DRAFT_INVOICE_NUM |
AGREEMENT_ID |