VIEW: APPS.PA_PROJ_UNBILLED_EXPEND_VIEW

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)