VIEW: APPS.PA_XLA_BC_BUDGET_HEADER_V

Source

View Text - Preformatted

SELECT xev.event_id, pbv.budget_version_id, xev.event_date, pbt.budget_amount_code, pbco.balance_type, pbco.external_budget_code, pbv.Project_id, pbv.version_number, pbv.Budget_type_code, pbt.Budget_type ,pbem.categorization_code ,pbco.gl_budget_version_id, pbv.Attribute1, pbv.Attribute2, pbv.Attribute3, pbv.Attribute4, pbv.Attribute5, pbv.Attribute6, pbv.Attribute7, pbv.Attribute8, pbv.Attribute9, pbv.Attribute10, pbv.Attribute11, pbv.Attribute12, pbv.Attribute13, pbv.Attribute14, pbv.Attribute15 from xla_events_gt xev, PA_BUDGET_VERSIONS pbv, PA_BUDGET_TYPES pbt, PA_BUDGETARY_CONTROL_OPTIONS pbco , PA_BUDGET_ENTRY_METHODS pbem WHERE xev.application_id = 275 and pbv.budget_version_id = xev.SOURCE_ID_INT_1 and PBCO.Project_Id = pbv.project_id and pbv.Budget_Type_Code = PBCO.Budget_Type_Code and pbv.budget_type_code = pbt.budget_type_code and pbv.budget_entry_method_code = pbem.budget_entry_method_code

View Text - HTML Formatted

SELECT XEV.EVENT_ID
, PBV.BUDGET_VERSION_ID
, XEV.EVENT_DATE
, PBT.BUDGET_AMOUNT_CODE
, PBCO.BALANCE_TYPE
, PBCO.EXTERNAL_BUDGET_CODE
, PBV.PROJECT_ID
, PBV.VERSION_NUMBER
, PBV.BUDGET_TYPE_CODE
, PBT.BUDGET_TYPE
, PBEM.CATEGORIZATION_CODE
, PBCO.GL_BUDGET_VERSION_ID
, PBV.ATTRIBUTE1
, PBV.ATTRIBUTE2
, PBV.ATTRIBUTE3
, PBV.ATTRIBUTE4
, PBV.ATTRIBUTE5
, PBV.ATTRIBUTE6
, PBV.ATTRIBUTE7
, PBV.ATTRIBUTE8
, PBV.ATTRIBUTE9
, PBV.ATTRIBUTE10
, PBV.ATTRIBUTE11
, PBV.ATTRIBUTE12
, PBV.ATTRIBUTE13
, PBV.ATTRIBUTE14
, PBV.ATTRIBUTE15
FROM XLA_EVENTS_GT XEV
, PA_BUDGET_VERSIONS PBV
, PA_BUDGET_TYPES PBT
, PA_BUDGETARY_CONTROL_OPTIONS PBCO
, PA_BUDGET_ENTRY_METHODS PBEM
WHERE XEV.APPLICATION_ID = 275
AND PBV.BUDGET_VERSION_ID = XEV.SOURCE_ID_INT_1
AND PBCO.PROJECT_ID = PBV.PROJECT_ID
AND PBV.BUDGET_TYPE_CODE = PBCO.BUDGET_TYPE_CODE
AND PBV.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PBV.BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE