VIEW: APPS.PA_XLA_BC_BUDGET_TXN_V

Source

View Text - Preformatted

SELECT (pp.name||' ( '||pp.segment1|| ' )'), Pbv.project_id, pbv.version_number, pbv.budget_version_id, pbv.budget_type_code, btype.budget_type, pp.org_id, btype.budget_amount_code, pbv.version_name from pa_budget_versions pbv, Pa_budget_types btype, Pa_Projects_All pp WHERE pbv.project_id = pp.project_id and btype.budget_type_code = pbv.budget_type_code and pbv.project_id = pp.project_id

View Text - HTML Formatted

SELECT (PP.NAME||' ( '||PP.SEGMENT1|| ' )')
, PBV.PROJECT_ID
, PBV.VERSION_NUMBER
, PBV.BUDGET_VERSION_ID
, PBV.BUDGET_TYPE_CODE
, BTYPE.BUDGET_TYPE
, PP.ORG_ID
, BTYPE.BUDGET_AMOUNT_CODE
, PBV.VERSION_NAME
FROM PA_BUDGET_VERSIONS PBV
, PA_BUDGET_TYPES BTYPE
, PA_PROJECTS_ALL PP
WHERE PBV.PROJECT_ID = PP.PROJECT_ID
AND BTYPE.BUDGET_TYPE_CODE = PBV.BUDGET_TYPE_CODE
AND PBV.PROJECT_ID = PP.PROJECT_ID