VIEW: APPS.GMS_STATUS_ACTUALS_V

Source

View Text - Preformatted

SELECT gsab2v.award_id, gsab2v.project_id, ppa.segment1, ppa.NAME, gsab2v.task_id, pat.task_number, pat.task_name, gsab2v.expenditure_item_id, pei.expenditure_type, pei.expenditure_item_date, pea.expenditure_group, pei.quantity, pal.meaning, pei.non_labor_resource, pts.user_transaction_source, pei.orig_transaction_reference, gsab2v.raw_cost, gsab2v.burdened_cost, gsab2v.revenue_amount, gsab2v.billed_amount, decode(gsab2v.invoice_id, null, null, (select invoice_num from ap_invoices_all WHERE invoice_id = gsab2v.invoice_id) ) supplier_invoice_num, pea.incurred_by_person_id incurred_by_person_id, pp.period_name pa_period, gsab2v.PA_DATE, gsab2v.GL_DATE, hrou1.name, hrou2.name, pp.org_id FROM pa_expenditure_items_all pei, pa_expenditures_all pea, pa_projects_all ppa, pa_tasks pat, pa_expenditure_types pet, gms_status_actuals_base1_v gsab2v, pa_lookups pal, pa_transaction_sources pts , pa_periods pp, hr_organization_units hrou1, hr_organization_units hrou2 WHERE gsab2v.expenditure_item_id = pei.expenditure_item_id AND pat.task_id = gsab2v.task_id AND pat.project_id = gsab2v.project_id and ppa.project_id = pat.project_id AND pei.expenditure_type = pet.expenditure_type AND pei.expenditure_id = pea.expenditure_id AND pet.unit_of_measure = pal.lookup_code AND pal.lookup_type = 'UNIT' AND pts.transaction_source(+) = pei.transaction_source AND gsab2v.pa_date between pp.start_date and pp.end_date AND hrou1.organization_id = nvl(pei.override_to_organization_id, pea.incurred_by_organization_id) AND pei.organization_id = hrou2.organization_id (+)

View Text - HTML Formatted

SELECT GSAB2V.AWARD_ID
, GSAB2V.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, GSAB2V.TASK_ID
, PAT.TASK_NUMBER
, PAT.TASK_NAME
, GSAB2V.EXPENDITURE_ITEM_ID
, PEI.EXPENDITURE_TYPE
, PEI.EXPENDITURE_ITEM_DATE
, PEA.EXPENDITURE_GROUP
, PEI.QUANTITY
, PAL.MEANING
, PEI.NON_LABOR_RESOURCE
, PTS.USER_TRANSACTION_SOURCE
, PEI.ORIG_TRANSACTION_REFERENCE
, GSAB2V.RAW_COST
, GSAB2V.BURDENED_COST
, GSAB2V.REVENUE_AMOUNT
, GSAB2V.BILLED_AMOUNT
, DECODE(GSAB2V.INVOICE_ID
, NULL
, NULL
, (SELECT INVOICE_NUM
FROM AP_INVOICES_ALL
WHERE INVOICE_ID = GSAB2V.INVOICE_ID) ) SUPPLIER_INVOICE_NUM
, PEA.INCURRED_BY_PERSON_ID INCURRED_BY_PERSON_ID
, PP.PERIOD_NAME PA_PERIOD
, GSAB2V.PA_DATE
, GSAB2V.GL_DATE
, HROU1.NAME
, HROU2.NAME
, PP.ORG_ID
FROM PA_EXPENDITURE_ITEMS_ALL PEI
, PA_EXPENDITURES_ALL PEA
, PA_PROJECTS_ALL PPA
, PA_TASKS PAT
, PA_EXPENDITURE_TYPES PET
, GMS_STATUS_ACTUALS_BASE1_V GSAB2V
, PA_LOOKUPS PAL
, PA_TRANSACTION_SOURCES PTS
, PA_PERIODS PP
, HR_ORGANIZATION_UNITS HROU1
, HR_ORGANIZATION_UNITS HROU2
WHERE GSAB2V.EXPENDITURE_ITEM_ID = PEI.EXPENDITURE_ITEM_ID
AND PAT.TASK_ID = GSAB2V.TASK_ID
AND PAT.PROJECT_ID = GSAB2V.PROJECT_ID
AND PPA.PROJECT_ID = PAT.PROJECT_ID
AND PEI.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE
AND PEI.EXPENDITURE_ID = PEA.EXPENDITURE_ID
AND PET.UNIT_OF_MEASURE = PAL.LOOKUP_CODE
AND PAL.LOOKUP_TYPE = 'UNIT'
AND PTS.TRANSACTION_SOURCE(+) = PEI.TRANSACTION_SOURCE
AND GSAB2V.PA_DATE BETWEEN PP.START_DATE
AND PP.END_DATE
AND HROU1.ORGANIZATION_ID = NVL(PEI.OVERRIDE_TO_ORGANIZATION_ID
, PEA.INCURRED_BY_ORGANIZATION_ID)
AND PEI.ORGANIZATION_ID = HROU2.ORGANIZATION_ID (+)