View: PABV_INVOICE_LINE_DETAILS

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_INVOICE_LINE_DETAILS

View Text

SELECT PCER.LINE_NUM
, PCER.EVENT_NUM
, PCER.TASK_ID
, PCER.DRAFT_REVENUE_NUM
, PCER.AMOUNT
, TO_NUMBER(NULL)
, PCER.CREATION_DATE
, PCER.CREATED_BY
FROM PA_CUST_EVENT_RDL_ALL PCER
, PA_DRAFT_INVOICE_ITEMS PDII
WHERE PCER.PROJECT_ID = PDII.PROJECT_ID(+)
AND PCER.DRAFT_INVOICE_NUM = PDII.DRAFT_INVOICE_NUM(+)
AND PCER.DRAFT_INVOICE_ITEM_LINE_NUM = PDII.LINE_NUM(+)
AND PCER.DRAFT_INVOICE_NUM IS NOT NULL
AND PCER.DRAFT_INVOICE_ITEM_LINE_NUM IS NOT NULL AND '_SEC:PCER.ORG_ID' IS NOT NULL UNION SELECT PCRD.LINE_NUM
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PCRD.DRAFT_REVENUE_NUM
, PCRD.AMOUNT
, PCRD.EXPENDITURE_ITEM_ID
, PCRD.CREATION_DATE
, PCRD.CREATED_BY
FROM PA_CUST_REV_DIST_LINES_ALL PCRD
, PA_DRAFT_INVOICE_ITEMS PDII
WHERE PCRD.PROJECT_ID = PDII.PROJECT_ID(+)
AND PCRD.DRAFT_INVOICE_NUM = PDII.DRAFT_INVOICE_NUM(+)
AND PCRD.DRAFT_INVOICE_ITEM_LINE_NUM = PDII.LINE_NUM(+)
AND PCRD.DRAFT_INVOICE_NUM IS NOT NULL
AND PCRD.DRAFT_INVOICE_ITEM_LINE_NUM IS NOT NULL AND '_SEC:PCRD.ORG_ID' IS NOT NULL WITH READ ONLY

Columns