View: PQH_BUDGETS_V

Product:	PQH - Public Sector HR
Description:	Budgets View
Implementation/DBA Data:	APPS.PQH_BUDGETS_V

View Text

SELECT BGT.BUDGET_ID BUDGET_ID
, BGT.BUDGET_NAME BUDGET_NAME
, BGT.PERIOD_SET_NAME PERIOD_SET_NAME
, PC.ACTUAL_PERIOD_TYPE PERIOD_TYPE
, BGT.BUDGET_START_DATE BUDGET_START_DATE
, BGT.BUDGET_END_DATE BUDGET_END_DATE
, HR_GENERAL.DECODE_LOOKUP('PQH_BUDGET_ENTITY'
, BGT.BUDGETED_ENTITY_CD) BUDGETED_ENTITY
, BGT.BUDGETED_ENTITY_CD BUDGETED_ENTITY_CD
, HR_GENERAL.DECODE_LOOKUP('PQH_BUDGET_STYLE'
, BGT.BUDGET_STYLE_CD) BUDGET_STYLE
, BGT.BUDGET_STYLE_CD BUDGET_STYLE_CD
, OS.NAME ORG_STRUCTURE
, BGT.ORG_STRUCTURE_VERSION_ID ORG_STRUCTURE_VERSION_ID
, OV.VERSION_NUMBER VERSION
, HR_GENERAL.DECODE_ORGANIZATION(BGT.START_ORGANIZATION_ID) START_ORGANIZATION
, BGT.START_ORGANIZATION_ID START_ORGANIZATION_ID
, BGT.CURRENCY_CODE CURRENCY_CODE
, PST1.SHARED_TYPE_NAME BUDGET_UNIT1
, BGT.BUDGET_UNIT1_ID BUDGET_UNIT1_ID
, PST2.SHARED_TYPE_NAME BUDGET_UNIT2
, BGT.BUDGET_UNIT2_ID BUDGET_UNIT2_ID
, PST3.SHARED_TYPE_NAME BUDGET_UNIT3
, BGT.BUDGET_UNIT3_ID BUDGET_UNIT3_ID
, BGT.TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG
, BGT.STATUS STATUS
, BGT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BGT.CREATED_BY CREATED_BY
, BGT.CREATION_DATE CREATION_DATE
, BGT.LAST_UPDATED_BY LAST_UPDATED_BY
, BGT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BGT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BGT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BGT.GL_SET_OF_BOOKS_ID GL_SET_OF_BOOKS_ID
, SOB.NAME GL_SOB_NAME
, HR_GENERAL.DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE'
, BGT.BUDGET_UNIT1_AGGREGATE) BUDGET_UNIT1_AGGREGATE_DESC
, BGT.BUDGET_UNIT1_AGGREGATE BUDGET_UNIT1_AGGREGATE
, HR_GENERAL.DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE'
, BGT.BUDGET_UNIT2_AGGREGATE) BUDGET_UNIT2_AGGREGATE_DESC
, BGT.BUDGET_UNIT2_AGGREGATE BUDGET_UNIT2_AGGREGATE
, HR_GENERAL.DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE'
, BGT.BUDGET_UNIT3_AGGREGATE) BUDGET_UNIT3_AGGREGATE_DESC
, BGT.BUDGET_UNIT3_AGGREGATE BUDGET_UNIT3_AGGREGATE
, BGT.POSITION_CONTROL_FLAG POSITION_CONTROL_FLAG
, BGT.VALID_GRADE_REQD_FLAG VALID_GRADE_REQD_FLAG
, BGT.TRANSFER_TO_GRANTS_FLAG TRANSFER_TO_GRANTS_FLAG
, BGT.PSB_BUDGET_FLAG PSB_BUDGET_FLAG
, BGT.GL_BUDGET_NAME GL_BUDGET_NAME
, PC.DISPLAY_PERIOD_TYPE DISPLAY_PERIOD_TYPE
FROM PQH_BUDGETS BGT
, PAY_CALENDARS_V PC
, PER_SHARED_TYPES_VL PST1
, PER_SHARED_TYPES_VL PST2
, PER_SHARED_TYPES_VL PST3
, PER_ORGANIZATION_STRUCTURES OS
, PER_ORG_STRUCTURE_VERSIONS OV
, GL_SETS_OF_BOOKS SOB
WHERE BGT.PERIOD_SET_NAME = PC.PERIOD_SET_NAME
AND BGT.BUDGET_UNIT1_ID =PST1.SHARED_TYPE_ID (+)
AND BGT.BUDGET_UNIT2_ID = PST2.SHARED_TYPE_ID (+)
AND BGT.BUDGET_UNIT3_ID = PST3.SHARED_TYPE_ID (+)
AND BGT.GL_SET_OF_BOOKS_ID =SOB.SET_OF_BOOKS_ID (+)
AND OS.ORGANIZATION_STRUCTURE_ID(+) = OV.ORGANIZATION_STRUCTURE_ID
AND OV.ORG_STRUCTURE_VERSION_ID(+) = BGT.ORG_STRUCTURE_VERSION_ID
AND NVL(PST1.BUSINESS_GROUP_ID(+)
, BGT.BUSINESS_GROUP_ID) = BGT.BUSINESS_GROUP_ID
AND NVL(PST2.BUSINESS_GROUP_ID(+)
, BGT.BUSINESS_GROUP_ID) = BGT.BUSINESS_GROUP_ID
AND NVL(PST3.BUSINESS_GROUP_ID(+)
, BGT.BUSINESS_GROUP_ID) = BGT.BUSINESS_GROUP_ID

Columns