VIEW: APPS.PA_INV_BURDEN_DETAILS_V

Source

View Text - Preformatted

SELECT p.segment1 , p.name , rdl.project_id , rdl.draft_invoice_num , di.ra_invoice_number , di.bill_through_date , di.released_date , di.invoice_date , di.gl_date , rdl.draft_invoice_item_line_num , ei.expenditure_item_id , rdl.line_num , t.task_number , t.task_name , t.task_id , bdb.expenditure_organization , bdb.expenditure_organization_id , ei.expenditure_type , ei.expenditure_item_date , rdl.raw_cost , ei.project_currency_code , rdl.bill_amount ,PA_CURRENCY.ROUND_CURRENCY_AMT(rdl.raw_cost * bdb.compiled_multiplier) , bdb.cost_base , bdb.cb_sort_order , bdb.burden_cost_code , bdb.bcc_precedence , bdb.input_multiplier , bdb.compiled_multiplier , bdb.burden_schedule , bdb.burden_schedule_id , bdb.burden_schedule_revision , bdb.burden_schedule_revision_id , bdb.burden_structure , bdb.compiled_set_id , di.org_id FROM pa_burden_details_base_v bdb, pa_draft_invoice_items dii, pa_draft_invoices di, pa_expenditures_all e, pa_tasks t, pa_projects_all p, pa_expenditure_items_all ei, pa_cust_rev_dist_lines_all rdl WHERE bdb.compiled_set_id = rdl.inv_ind_compiled_set_id AND bdb.expenditure_type = ei.expenditure_type AND bdb.expenditure_organization_id = nvl(ei.override_to_organization_id, e.incurred_by_organization_id) AND ei.expenditure_item_id = rdl.expenditure_item_id AND rdl.project_id = dii.project_id AND rdl.draft_invoice_num = dii.draft_invoice_num AND rdl.draft_invoice_item_line_num = dii.line_num AND di.project_id = dii.project_id AND di.draft_invoice_num = dii.draft_invoice_num AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT' AND e.expenditure_id = ei.expenditure_id AND t.task_id = ei.task_id AND p.project_id = rdl.project_id

View Text - HTML Formatted

SELECT P.SEGMENT1
, P.NAME
, RDL.PROJECT_ID
, RDL.DRAFT_INVOICE_NUM
, DI.RA_INVOICE_NUMBER
, DI.BILL_THROUGH_DATE
, DI.RELEASED_DATE
, DI.INVOICE_DATE
, DI.GL_DATE
, RDL.DRAFT_INVOICE_ITEM_LINE_NUM
, EI.EXPENDITURE_ITEM_ID
, RDL.LINE_NUM
, T.TASK_NUMBER
, T.TASK_NAME
, T.TASK_ID
, BDB.EXPENDITURE_ORGANIZATION
, BDB.EXPENDITURE_ORGANIZATION_ID
, EI.EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_DATE
, RDL.RAW_COST
, EI.PROJECT_CURRENCY_CODE
, RDL.BILL_AMOUNT
, PA_CURRENCY.ROUND_CURRENCY_AMT(RDL.RAW_COST * BDB.COMPILED_MULTIPLIER)
, BDB.COST_BASE
, BDB.CB_SORT_ORDER
, BDB.BURDEN_COST_CODE
, BDB.BCC_PRECEDENCE
, BDB.INPUT_MULTIPLIER
, BDB.COMPILED_MULTIPLIER
, BDB.BURDEN_SCHEDULE
, BDB.BURDEN_SCHEDULE_ID
, BDB.BURDEN_SCHEDULE_REVISION
, BDB.BURDEN_SCHEDULE_REVISION_ID
, BDB.BURDEN_STRUCTURE
, BDB.COMPILED_SET_ID
, DI.ORG_ID
FROM PA_BURDEN_DETAILS_BASE_V BDB
, PA_DRAFT_INVOICE_ITEMS DII
, PA_DRAFT_INVOICES DI
, PA_EXPENDITURES_ALL E
, PA_TASKS T
, PA_PROJECTS_ALL P
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_CUST_REV_DIST_LINES_ALL RDL
WHERE BDB.COMPILED_SET_ID = RDL.INV_IND_COMPILED_SET_ID
AND BDB.EXPENDITURE_TYPE = EI.EXPENDITURE_TYPE
AND BDB.EXPENDITURE_ORGANIZATION_ID = NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)
AND EI.EXPENDITURE_ITEM_ID = RDL.EXPENDITURE_ITEM_ID
AND RDL.PROJECT_ID = DII.PROJECT_ID
AND RDL.DRAFT_INVOICE_NUM = DII.DRAFT_INVOICE_NUM
AND RDL.DRAFT_INVOICE_ITEM_LINE_NUM = DII.LINE_NUM
AND DI.PROJECT_ID = DII.PROJECT_ID
AND DI.DRAFT_INVOICE_NUM = DII.DRAFT_INVOICE_NUM
AND DII.INVOICE_LINE_TYPE <> 'NET ZERO ADJUSTMENT'
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND T.TASK_ID = EI.TASK_ID
AND P.PROJECT_ID = RDL.PROJECT_ID