VIEW: APPS.PA_PROJ_INVOICE_DETAILS_VIEW

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'