View: PA_BUDGET_LINES_DIST_V

Product:	PA - Projects
Description:	PA_BUDGET_LINES_DIST_V stores the information of a project or task budget by budget line, including the task number and sort order; the resource, period name, and budget amounts; and the code combination identifier and rejection message.
Implementation/DBA Data:	APPS.PA_BUDGET_LINES_DIST_V

View Text

SELECT LN.ROWID
, LN.RESOURCE_ASSIGNMENT_ID
, A.BUDGET_VERSION_ID
, A.PROJECT_ID
, A.TASK_ID
, T.TASK_NUMBER
, LN.CODE_COMBINATION_ID
, M.RESOURCE_LIST_MEMBER_ID
, M.ALIAS
, LN.PERIOD_NAME
, LN.START_DATE
, LN.RAW_COST
, LN.BURDENED_COST
, LN.REVENUE
, LN.CCID_GEN_REJ_MESSAGE
, DECODE(T.TASK_NUMBER
, NULL
, '1'
, (PA_TASK_UTILS.SORT_ORDER_TREE_WALK(T.PARENT_TASK_ID
, T.TASK_NUMBER)))
FROM PA_BUDGET_LINES LN
, PA_RESOURCE_LIST_MEMBERS M
, PA_RESOURCE_ASSIGNMENTS A
, PA_TASKS T
WHERE LN.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.TASK_ID = T.TASK_ID (+)

Columns