VIEW: APPS.PA_BUDGET_LINES_DIST_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)