VIEW: APPS.GMS_STATUS_COMMITMENTS_V

Source

View Text - Preformatted

SELECT gcev.award_id, gcev.project_id, ppa.segment1, ppa.NAME, gcev.task_id, pat.task_number, pat.task_name, gcev.document_type, gcev.expenditure_type, gcev.expenditure_item_date, hrou.NAME, gcev.cmt_number, gcev.description, NVL (gcev.tot_cmt_quantity, 0), gcev.unit_of_measure, gcev.vendor_name, gcev.transaction_source, pa_currency.round_currency_amt (NVL (gcev.acct_raw_cost,0)), pa_currency.round_currency_amt (NVL (gcev.acct_burdened_cost,0)), pp.period_name, pp.org_id, gcev.gl_date FROM hr_organization_units hrou, pa_projects_all ppa, pa_tasks pat, pa_periods pp, gms_commitment_burden_v gcev WHERE gcev.task_id = pat.task_id AND pat.project_id = ppa.project_id AND hrou.organization_id = gcev.organization_id AND gcev.expenditure_item_date between pp.start_date and pp.end_date

View Text - HTML Formatted

SELECT GCEV.AWARD_ID
, GCEV.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, GCEV.TASK_ID
, PAT.TASK_NUMBER
, PAT.TASK_NAME
, GCEV.DOCUMENT_TYPE
, GCEV.EXPENDITURE_TYPE
, GCEV.EXPENDITURE_ITEM_DATE
, HROU.NAME
, GCEV.CMT_NUMBER
, GCEV.DESCRIPTION
, NVL (GCEV.TOT_CMT_QUANTITY
, 0)
, GCEV.UNIT_OF_MEASURE
, GCEV.VENDOR_NAME
, GCEV.TRANSACTION_SOURCE
, PA_CURRENCY.ROUND_CURRENCY_AMT (NVL (GCEV.ACCT_RAW_COST
, 0))
, PA_CURRENCY.ROUND_CURRENCY_AMT (NVL (GCEV.ACCT_BURDENED_COST
, 0))
, PP.PERIOD_NAME
, PP.ORG_ID
, GCEV.GL_DATE
FROM HR_ORGANIZATION_UNITS HROU
, PA_PROJECTS_ALL PPA
, PA_TASKS PAT
, PA_PERIODS PP
, GMS_COMMITMENT_BURDEN_V GCEV
WHERE GCEV.TASK_ID = PAT.TASK_ID
AND PAT.PROJECT_ID = PPA.PROJECT_ID
AND HROU.ORGANIZATION_ID = GCEV.ORGANIZATION_ID
AND GCEV.EXPENDITURE_ITEM_DATE BETWEEN PP.START_DATE
AND PP.END_DATE