VIEW: APPS.PQH_BUDGETS_V

Source

View Text - Preformatted

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, pqh_utility.get_shared_type_name ( bgt.budget_unit2_id, bgt.business_group_id) budget_unit2, bgt.budget_unit2_id budget_unit2_id, pqh_utility.get_shared_type_name ( bgt.budget_unit3_id, bgt.business_group_id), 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, bgt.dflt_budget_set_id, dbs.dflt_budget_set_name FROM pqh_budgets bgt, pay_calendars_v pc , per_shared_types_vl pst1 , per_organization_structures os, per_org_structure_versions ov, gl_sets_of_books sob, pqh_dflt_budget_sets dbs WHERE bgt.period_set_name = pc.period_set_name AND bgt.budget_unit1_id =pst1.shared_type_id AND bgt.gl_set_of_books_id =sob.set_of_books_id (+) AND bgt.dflt_budget_set_id = dbs.dflt_budget_set_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

View Text - HTML Formatted

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
, PQH_UTILITY.GET_SHARED_TYPE_NAME ( BGT.BUDGET_UNIT2_ID
, BGT.BUSINESS_GROUP_ID) BUDGET_UNIT2
, BGT.BUDGET_UNIT2_ID BUDGET_UNIT2_ID
, PQH_UTILITY.GET_SHARED_TYPE_NAME ( BGT.BUDGET_UNIT3_ID
, BGT.BUSINESS_GROUP_ID)
, 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
, BGT.DFLT_BUDGET_SET_ID
, DBS.DFLT_BUDGET_SET_NAME
FROM PQH_BUDGETS BGT
, PAY_CALENDARS_V PC
, PER_SHARED_TYPES_VL PST1
, PER_ORGANIZATION_STRUCTURES OS
, PER_ORG_STRUCTURE_VERSIONS OV
, GL_SETS_OF_BOOKS SOB
, PQH_DFLT_BUDGET_SETS DBS
WHERE BGT.PERIOD_SET_NAME = PC.PERIOD_SET_NAME
AND BGT.BUDGET_UNIT1_ID =PST1.SHARED_TYPE_ID
AND BGT.GL_SET_OF_BOOKS_ID =SOB.SET_OF_BOOKS_ID (+)
AND BGT.DFLT_BUDGET_SET_ID = DBS.DFLT_BUDGET_SET_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