Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_ENCUMBRANCE_ITEMS_V |
SELECT E.ROWID ROW_ID
, E.ENCUMBRANCE_ITEM_ID
, E.ENCUMBRANCE_ID
, T.PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, P.NAME PROJECT_NAME
, E.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, X.ENCUMBRANCE_GROUP
, X.ENCUMBRANCE_STATUS_CODE
, X.INCURRED_BY_PERSON_ID
, L.MEANING UNIT_OF_MEASURE_M
, E.SYSTEM_LINKAGE_FUNCTION
, E.ENCUMBRANCE_ITEM_DATE
, E.ENCUMBRANCE_TYPE
, E.ENC_DISTRIBUTED_FLAG
, E.OVERRIDE_TO_ORGANIZATION_ID
, E.ADJUSTED_ENCUMBRANCE_ITEM_ID
, E.NET_ZERO_ADJUSTMENT_FLAG
, E.TRANSFERRED_FROM_ENC_ITEM_ID
, E.LAST_UPDATE_LOGIN
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.CREATION_DATE
, E.CREATED_BY
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, E.ORIG_TRANSACTION_REFERENCE
, E.TRANSACTION_SOURCE
, E.SOURCE_ENCUMBRANCE_ITEM_ID
, E.JOB_ID
, TR.USER_TRANSACTION_SOURCE
, E.DENOM_CURRENCY_CODE
, E.DENOM_RAW_AMOUNT
, E.ACCT_EXCHANGE_ROUNDING_LIMIT
, E.ACCT_CURRENCY_CODE
, E.ACCT_RATE_DATE
, E.ACCT_RATE_TYPE
, E.ACCT_EXCHANGE_RATE
, E.ACCT_RAW_COST
, E.PROJECT_CURRENCY_CODE
, E.PROJECT_RATE_DATE
, E.PROJECT_RATE_TYPE
, E.PROJECT_EXCHANGE_RATE
, ET.COST_RATE_FLAG
, X.INCURRED_BY_ORGANIZATION_ID
, TR.ALLOW_REVERSAL_FLAG
, E.AMOUNT
, E.ENCUMBRANCE_COMMENT
, E.IND_COMPILED_SET_ID
, E.PA_DATE
, E.GL_DATE
, E.LINE_NUM
, E.BURDEN_SUM_DEST_RUN_ID
, E.BURDEN_SUM_SOURCE_RUN_ID
, X.ORG_ID
FROM PA_LOOKUPS L
, PA_EXPENDITURE_TYPES ET
, GMS_ENCUMBRANCES X
, PA_TASKS T
, PA_PROJECTS_ALL P
, PA_TRANSACTION_SOURCES TR
, GMS_ENCUMBRANCE_ITEMS_ALL E
WHERE T.PROJECT_ID = P.PROJECT_ID
AND E.TASK_ID = T.TASK_ID
AND E.ENCUMBRANCE_ID = X.ENCUMBRANCE_ID
AND E.ENCUMBRANCE_TYPE = ET.EXPENDITURE_TYPE
AND E.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+)
AND ET.UNIT_OF_MEASURE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'UNIT'