View: PA_PROJ_UNBILLED_EXPEND_VIEW

Product:	PA - Projects
Description:	Unbilled expenditure items for projects
Implementation/DBA Data:	APPS.PA_PROJ_UNBILLED_EXPEND_VIEW

View Text

SELECT
WHERE NOT EXISTS ( SELECT 'INVOICED'
FROM PA_CUST_REV_DIST_LINES RDL
, PA_DRAFT_INVOICE_ITEMS ITEM
WHERE RDL.EXPENDITURE_ITEM_ID = EXP.EXPENDITURE_ITEM_ID
AND RDL.PROJECT_ID = ITEM.PROJECT_ID
AND RDL.DRAFT_INVOICE_NUM = ITEM.DRAFT_INVOICE_NUM
AND RDL.DRAFT_INVOICE_ITEM_LINE_NUM = ITEM.LINE_NUM
AND ITEM.INVOICE_LINE_TYPE <> 'NET ZERO ADJUSTMENT')
AND EXP.BILLABLE_FLAG = 'Y'
AND EXP.EXPENDITURE_ITEM_ID IN ( SELECT EXPENDITURE_ITEM_ID
FROM PA_EXPENDITURE_ITEMS_ALL EI
WHERE EXP.PROJECT_ID = EI.PROJECT_ID
AND EI.EVENT_NUM IS NULL)

Columns