VIEW: APPS.GMS_ENCUMBRANCE_ITEMS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'