View: PAFV_INVOICE_LINE_DETAILS

Product:	PA - Projects
Description:	Business view to show the details of the invoice lines.
Implementation/DBA Data:	APPS.PAFV_INVOICE_LINE_DETAILS

View Text

SELECT PCER.LINE_NUM
, PCER.EVENT_NUM
, PCER.DRAFT_REVENUE_NUM
, PCER.AMOUNT
, PCER.TASK_ID
, PT.TASK_NAME
, PT.TASK_NUMBER
, PDII.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, TO_NUMBER(NULL)
, PCER.CREATION_DATE
, PCER.CREATED_BY
FROM PA_CUST_EVENT_RDL_ALL PCER
, PA_DRAFT_INVOICE_ITEMS PDII
, PA_TASKS PT
, PA_PROJECTS_ALL PPA
WHERE PCER.PROJECT_ID = PPA.PROJECT_ID
AND PCER.TASK_ID = PT.TASK_ID(+)
AND 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)
, PCRD.DRAFT_REVENUE_NUM
, PCRD.AMOUNT
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, TO_CHAR(NULL)
, PDII.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PCRD.EXPENDITURE_ITEM_ID
, PCRD.CREATION_DATE
, PCRD.CREATED_BY
FROM PA_CUST_REV_DIST_LINES_ALL PCRD
, PA_DRAFT_INVOICE_ITEMS PDII
, PA_PROJECTS_ALL PPA
WHERE PCRD.PROJECT_ID = PPA.PROJECT_ID
AND 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