View: GMS_STATUS_ACTUALS_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_STATUS_ACTUALS_V

View Text

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 (+)

Columns