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 EXP.PROJECT_ID
, EXP.ON_HOLD_FLAG
, EXP.EMPLOYEE_VENDOR_NAME
, EXP.EMPLOYEE_VENDOR_NUM
, EXP.INCURRED_BY_ORGANIZATION_ID
, EXP.OVERRIDE_TO_ORGANIZATION_ID
, EXP.INCURRED_BY_ORGANIZATION_NAME
, EXP.JOB_RESOURCE_ORG_NAME
, EXP.EXPENDITURE_TYPE
, EXP.TASK_NUMBER
, EXP.EXPENDITURE_ITEM_DATE
, EXP.QUANTITY
, EXP.UNIT_OF_MEASURE
, EXP.BILL_RATE
, EXP.BILL_AMOUNT
, EXP.INVPROC_CURRENCY_CODE
, EXP.BILL_TRANS_CURRENCY_CODE
, EXP.BILL_TRANS_BILL_AMOUNT
FROM PA_PROJ_EXPEND_VIEW EXP
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