VIEW: APPS.GMS_BUDGET_LINES_V

Source

View Text - Preformatted

SELECT I.ROWID , I.RESOURCE_ASSIGNMENT_ID , A.BUDGET_VERSION_ID , A.PROJECT_ID , A.TASK_ID , A.RESOURCE_LIST_MEMBER_ID , M.RESOURCE_LIST_ID , M.RESOURCE_ID , M.ALIAS , I.DESCRIPTION , I.START_DATE , I.END_DATE , I.PERIOD_NAME , I.QUANTITY , A.UNIT_OF_MEASURE , L1.MEANING , A.TRACK_AS_LABOR_FLAG , I.RAW_COST , I.BURDENED_COST , I.REVENUE , I.CHANGE_REASON_CODE , L2.MEANING , I.LAST_UPDATE_DATE , I.LAST_UPDATED_BY , I.CREATION_DATE , I.CREATED_BY , I.LAST_UPDATE_LOGIN , I.ATTRIBUTE_CATEGORY , I.ATTRIBUTE1 , I.ATTRIBUTE2 , I.ATTRIBUTE3 , I.ATTRIBUTE4 , I.ATTRIBUTE5 , I.ATTRIBUTE6 , I.ATTRIBUTE7 , I.ATTRIBUTE8 , I.ATTRIBUTE9 , I.ATTRIBUTE10 , I.ATTRIBUTE11 , I.ATTRIBUTE12 , I.ATTRIBUTE13 , I.ATTRIBUTE14 , I.ATTRIBUTE15 , i.raw_cost_source , i.burdened_cost_source , i.quantity_source , i.revenue_source ,i.PM_PRODUCT_CODE ,i.PM_BUDGET_LINE_REFERENCE FROM PA_LOOKUPS L2, PA_LOOKUPS L1, GMS_BUDGET_LINES I, PA_RESOURCE_LIST_MEMBERS M, GMS_RESOURCE_ASSIGNMENTS A WHERE I.RESOURCE_ASSIGNMENT_ID = A.RESOURCE_ASSIGNMENT_ID AND A.RESOURCE_LIST_MEMBER_ID = M.RESOURCE_LIST_MEMBER_ID AND A.UNIT_OF_MEASURE = L1.LOOKUP_CODE (+) AND L1.LOOKUP_TYPE (+) = 'UNIT' AND I.CHANGE_REASON_CODE = L2.LOOKUP_CODE (+) AND L2.LOOKUP_TYPE (+) = 'BUDGET CHANGE REASON'

View Text - HTML Formatted

SELECT I.ROWID
, I.RESOURCE_ASSIGNMENT_ID
, A.BUDGET_VERSION_ID
, A.PROJECT_ID
, A.TASK_ID
, A.RESOURCE_LIST_MEMBER_ID
, M.RESOURCE_LIST_ID
, M.RESOURCE_ID
, M.ALIAS
, I.DESCRIPTION
, I.START_DATE
, I.END_DATE
, I.PERIOD_NAME
, I.QUANTITY
, A.UNIT_OF_MEASURE
, L1.MEANING
, A.TRACK_AS_LABOR_FLAG
, I.RAW_COST
, I.BURDENED_COST
, I.REVENUE
, I.CHANGE_REASON_CODE
, L2.MEANING
, I.LAST_UPDATE_DATE
, I.LAST_UPDATED_BY
, I.CREATION_DATE
, I.CREATED_BY
, I.LAST_UPDATE_LOGIN
, I.ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1
, I.ATTRIBUTE2
, I.ATTRIBUTE3
, I.ATTRIBUTE4
, I.ATTRIBUTE5
, I.ATTRIBUTE6
, I.ATTRIBUTE7
, I.ATTRIBUTE8
, I.ATTRIBUTE9
, I.ATTRIBUTE10
, I.ATTRIBUTE11
, I.ATTRIBUTE12
, I.ATTRIBUTE13
, I.ATTRIBUTE14
, I.ATTRIBUTE15
, I.RAW_COST_SOURCE
, I.BURDENED_COST_SOURCE
, I.QUANTITY_SOURCE
, I.REVENUE_SOURCE
, I.PM_PRODUCT_CODE
, I.PM_BUDGET_LINE_REFERENCE
FROM PA_LOOKUPS L2
, PA_LOOKUPS L1
, GMS_BUDGET_LINES I
, PA_RESOURCE_LIST_MEMBERS M
, GMS_RESOURCE_ASSIGNMENTS A
WHERE I.RESOURCE_ASSIGNMENT_ID = A.RESOURCE_ASSIGNMENT_ID
AND A.RESOURCE_LIST_MEMBER_ID = M.RESOURCE_LIST_MEMBER_ID
AND A.UNIT_OF_MEASURE = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'UNIT'
AND I.CHANGE_REASON_CODE = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE (+) = 'BUDGET CHANGE REASON'