Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_STATUS_COMMITMENTS_V |
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