View: PA_PROJ_INVOICE_DETAILS_VIEW

Product:	PA - Projects
Description:	View of detail expenditure items included on project invoices. Full Description: is a view that displays the detailed expenditure items that backup a project invoice. You can use this view to easily report the expenditure item informatio
Implementation/DBA Data:	APPS.PA_PROJ_INVOICE_DETAILS_VIEW

View Text

SELECT RDL.PROJECT_ID
, RDL.EXPENDITURE_ITEM_ID
, EXP.EMPLOYEE_VENDOR_NAME
, EXP.EMPLOYEE_VENDOR_NUM
, EXP.INCURRED_BY_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
, DECODE(RDL.LINE_NUM_REVERSED
, NULL
, RDL.BILL_RATE
, NULL)
, RDL.BILL_AMOUNT
, RDL.DRAFT_INVOICE_NUM
, RDL.DRAFT_INVOICE_ITEM_LINE_NUM
FROM PA_PROJ_EXPEND_VIEW EXP
, PA_CUST_REV_DIST_LINES RDL
, PA_DRAFT_INVOICE_ITEMS ITEM
WHERE EXP.EXPENDITURE_ITEM_ID = RDL.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'

Columns