View: PA_BUDGET_LINES_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_BUDGET_LINES_V

View Text

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
, I.TXN_CURRENCY_CODE
FROM PA_LOOKUPS L2
, PA_LOOKUPS L1
, PA_BUDGET_LINES I
, PA_RESOURCE_LIST_MEMBERS M
, PA_RESOURCE_ASSIGNMENTS A
WHERE I.RESOURCE_ASSIGNMENT_ID = A.RESOURCE_ASSIGNMENT_ID
AND A.RESOURCE_LIST_MEMBER_ID = M.RESOURCE_LIST_MEMBER_ID
AND NVL(M.MIGRATION_CODE
, '-99') <> 'N'
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'

Columns