VIEW: APPS.PA_CE_INTEGRATION_BUDGETS_V

Source

View Text - Preformatted

SELECT l.resource_assignment_id , m.ALIAS trx_number , v.budget_version_id , a.project_id , a.task_id , decode(v.budget_type_code,NULL, (select name from pa_fin_plan_types_vl f where v.fin_plan_type_id = f.fin_plan_type_id) ,v.budget_type_code) , v.current_flag , v.current_original_flag , l.start_date , l.end_date , l.period_name , GL.currency_code , l.raw_cost , l.burdened_cost , l.revenue FROM pa_budget_lines l , pa_budget_versions v , pa_resource_list_members m , pa_resource_assignments a , pa_projects_all p , pa_implementations_all i , GL_SETS_OF_BOOKS gl WHERE l.resource_assignment_id = a.resource_assignment_id AND a.resource_list_member_id = m.resource_list_member_id AND a.budget_version_id = v.budget_version_id AND a.project_id = v.project_id AND v.project_id = p.project_id AND nvl(p.org_id, -99) = nvl(i.org_id, -99) AND i.set_of_books_id = gl.set_of_books_id AND (v.current_flag = 'Y' OR v.current_original_flag = 'Y')

View Text - HTML Formatted

SELECT L.RESOURCE_ASSIGNMENT_ID
, M.ALIAS TRX_NUMBER
, V.BUDGET_VERSION_ID
, A.PROJECT_ID
, A.TASK_ID
, DECODE(V.BUDGET_TYPE_CODE
, NULL
, (SELECT NAME
FROM PA_FIN_PLAN_TYPES_VL F
WHERE V.FIN_PLAN_TYPE_ID = F.FIN_PLAN_TYPE_ID)
, V.BUDGET_TYPE_CODE)
, V.CURRENT_FLAG
, V.CURRENT_ORIGINAL_FLAG
, L.START_DATE
, L.END_DATE
, L.PERIOD_NAME
, GL.CURRENCY_CODE
, L.RAW_COST
, L.BURDENED_COST
, L.REVENUE
FROM PA_BUDGET_LINES L
, PA_BUDGET_VERSIONS V
, PA_RESOURCE_LIST_MEMBERS M
, PA_RESOURCE_ASSIGNMENTS A
, PA_PROJECTS_ALL P
, PA_IMPLEMENTATIONS_ALL I
, GL_SETS_OF_BOOKS GL
WHERE L.RESOURCE_ASSIGNMENT_ID = A.RESOURCE_ASSIGNMENT_ID
AND A.RESOURCE_LIST_MEMBER_ID = M.RESOURCE_LIST_MEMBER_ID
AND A.BUDGET_VERSION_ID = V.BUDGET_VERSION_ID
AND A.PROJECT_ID = V.PROJECT_ID
AND V.PROJECT_ID = P.PROJECT_ID
AND NVL(P.ORG_ID
, -99) = NVL(I.ORG_ID
, -99)
AND I.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND (V.CURRENT_FLAG = 'Y' OR V.CURRENT_ORIGINAL_FLAG = 'Y')