VIEW: APPS.PQH_POS_WORKSHEETS_V

Source

View Text - Preformatted

SELECT wrk.worksheet_id worksheet_id, wrk.worksheet_name worksheet_name, wrk.action_date action_date, wrk.worksheet_mode_cd worksheet_mode_cd, wrk.PROPAGATION_METHOD PROPAGATION_METHOD, wrk.TRANSACTION_STATUS TRANSACTION_STATUS, bgt.BUDGET_NAME || ' (' || fnd_date.date_to_displaydate(bgt.budget_start_date, 1) || ' - ' || fnd_date.date_to_displaydate(bgt.budget_end_date, 1) || ')' BUDGET_DISPLAY_NAME , bgt.BUDGET_NAME BUDGET_NAME , bgt.BUDGET_ID BUDGET_ID , bgt.period_set_name period_set_name, bgt.BUDGET_START_DATE BUDGET_START_DATE , bgt.BUDGET_END_DATE BUDGET_END_DATE , bgt.budgeted_entity_cd budgeted_entity_cd, bgt.budget_style_cd budget_style_cd, bgt.position_control_flag position_control_flag, bgt.transfer_to_gl_flag transfer_to_gl_flag, bgt.currency_code currency_code, bgt.BUDGET_UNIT1_ID BUDGET_UNIT1_ID, pst1.system_type_cd BUDGET_UNIT1_TYPE_CD, pst1.shared_type_name BUDGET_MEASUREMENT_TYPE1, bgt.BUDGET_UNIT1_AGGREGATE BUDGET_UNIT1_AGGREGATE, HR_GENERAL.DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE' , bgt.budget_unit1_aggregate) BUDGET_UNIT_AGGREGATE_DESC1 , bgt.BUDGET_UNIT2_ID BUDGET_UNIT2_ID, pst2.system_type_cd BUDGET_UNIT2_TYPE_CD, pst2.shared_type_name BUDGET_MEASUREMENT_TYPE2 , bgt.BUDGET_UNIT2_AGGREGATE BUDGET_UNIT2_AGGREGATE, HR_GENERAL.DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE' , bgt.budget_unit2_aggregate) BUDGET_UNIT_AGGREGATE_DESC2 , bgt.BUDGET_UNIT3_ID BUDGET_UNIT3_ID, pst3.system_type_cd BUDGET_UNIT3_TYPE_CD, pst3.shared_type_name BUDGET_MEASUREMENT_TYPE3 , bgt.BUDGET_UNIT3_AGGREGATE BUDGET_UNIT3_AGGREGATE, HR_GENERAL.DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE' , bgt.budget_unit3_aggregate) BUDGET_UNIT_AGGREGATE_DESC3 , bgt.BUSINESS_GROUP_ID BUSINESS_GROUP_ID , bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID , bvr.VERSION_NUMBER BUDGET_VERSION_NUMBER , bvr.DATE_FROM BUDGET_VERSION_START_DATE , bvr.DATE_TO BUDGET_VERSION_END_DATE , bvr.BUDGET_UNIT1_VALUE BUDGET_UNIT1_VALUE, bvr.BUDGET_UNIT2_VALUE BUDGET_UNIT2_VALUE, bvr.BUDGET_UNIT3_VALUE BUDGET_UNIT3_VALUE, bvr.BUDGET_UNIT1_AVAILABLE BUDGET_UNIT1_AVAILABLE, bvr.BUDGET_UNIT2_AVAILABLE BUDGET_UNIT2_AVAILABLE, bvr.BUDGET_UNIT3_AVAILABLE BUDGET_UNIT3_AVAILABLE, bvr.GL_STATUS BUDGET_VERSION_GL_STATUS, wdt.WORKSHEET_DETAIL_ID WORKSHEET_DETAIL_ID , wdt.BUDGET_DETAIL_ID BUDGET_DETAIL_ID , wdt.BUDGET_UNIT1_VALUE_TYPE_CD POSITION_UNIT1_VALUE_TYPE_CD, wdt.BUDGET_UNIT2_VALUE_TYPE_CD POSITION_UNIT2_VALUE_TYPE_CD, wdt.BUDGET_UNIT3_VALUE_TYPE_CD POSITION_UNIT3_VALUE_TYPE_CD, wdt.BUDGET_UNIT1_VALUE POSITION_UNIT1_VALUE, wdt.BUDGET_UNIT2_VALUE POSITION_UNIT2_VALUE, wdt.BUDGET_UNIT3_VALUE POSITION_UNIT3_VALUE, wdt.BUDGET_UNIT1_AVAILABLE POSITION_UNIT1_AVAILABLE, wdt.BUDGET_UNIT2_AVAILABLE POSITION_UNIT2_AVAILABLE, wdt.BUDGET_UNIT3_AVAILABLE POSITION_UNIT3_AVAILABLE, wdt.BUDGET_UNIT1_PERCENT POSITION_UNIT1_PERCENT, wdt.BUDGET_UNIT2_PERCENT POSITION_UNIT2_PERCENT, wdt.BUDGET_UNIT3_PERCENT POSITION_UNIT3_PERCENT, wdt.OLD_UNIT1_VALUE OLD_UNIT1_VALUE, wdt.OLD_UNIT2_VALUE OLD_UNIT2_VALUE, wdt.OLD_UNIT3_VALUE OLD_UNIT3_VALUE, wdt.ACTION_CD ACTION_CD, wdt.POSITION_TRANSACTION_ID POSITION_TRANSACTION_ID, wdt.POSITION_ID POSITION_ID, wdt.organization_id organization_id, wdt.job_id job_id, wdt.grade_id grade_id, wdt.object_version_number object_version_number, wdt.last_updated_by last_updated_by, wdt.last_update_date last_update_date, wdt.last_update_login last_update_login, wdt.created_by created_by, wdt.creation_date creation_date , bgt.dflt_budget_set_id dflt_budget_set_id, dbs.dflt_budget_set_name dflt_budget_set_name FROM pqh_budgets bgt , pqh_budget_versions bvr , pqh_worksheet_details wdt, fnd_sessions ses, pqh_dflt_budget_sets dbs, per_shared_types_vl pst1, per_shared_types_vl pst2, per_shared_types_vl pst3, pqh_worksheets wrk WHERE bgt.budget_id = bvr.budget_id AND bvr.budget_version_id = wrk.budget_version_id AND wrk.worksheet_id = wdt.worksheet_id and ses.session_id = userenv('sessionid') AND ses.effective_date between bvr.DATE_FROM and nvl(bvr.DATE_to, hr_general.end_of_time) AND bgt.dflt_budget_set_id = dbs.dflt_budget_set_id(+) 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.budgeted_entity_cd='POSITION' and wrk.budget_id = wrk.budget_id AND wrk.worksheet_mode_cd = 'O'

View Text - HTML Formatted

SELECT WRK.WORKSHEET_ID WORKSHEET_ID
, WRK.WORKSHEET_NAME WORKSHEET_NAME
, WRK.ACTION_DATE ACTION_DATE
, WRK.WORKSHEET_MODE_CD WORKSHEET_MODE_CD
, WRK.PROPAGATION_METHOD PROPAGATION_METHOD
, WRK.TRANSACTION_STATUS TRANSACTION_STATUS
, BGT.BUDGET_NAME || ' (' || FND_DATE.DATE_TO_DISPLAYDATE(BGT.BUDGET_START_DATE
, 1) || ' - ' || FND_DATE.DATE_TO_DISPLAYDATE(BGT.BUDGET_END_DATE
, 1) || ')' BUDGET_DISPLAY_NAME
, BGT.BUDGET_NAME BUDGET_NAME
, BGT.BUDGET_ID BUDGET_ID
, BGT.PERIOD_SET_NAME PERIOD_SET_NAME
, BGT.BUDGET_START_DATE BUDGET_START_DATE
, BGT.BUDGET_END_DATE BUDGET_END_DATE
, BGT.BUDGETED_ENTITY_CD BUDGETED_ENTITY_CD
, BGT.BUDGET_STYLE_CD BUDGET_STYLE_CD
, BGT.POSITION_CONTROL_FLAG POSITION_CONTROL_FLAG
, BGT.TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG
, BGT.CURRENCY_CODE CURRENCY_CODE
, BGT.BUDGET_UNIT1_ID BUDGET_UNIT1_ID
, PST1.SYSTEM_TYPE_CD BUDGET_UNIT1_TYPE_CD
, PST1.SHARED_TYPE_NAME BUDGET_MEASUREMENT_TYPE1
, BGT.BUDGET_UNIT1_AGGREGATE BUDGET_UNIT1_AGGREGATE
, HR_GENERAL.DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE'
, BGT.BUDGET_UNIT1_AGGREGATE) BUDGET_UNIT_AGGREGATE_DESC1
, BGT.BUDGET_UNIT2_ID BUDGET_UNIT2_ID
, PST2.SYSTEM_TYPE_CD BUDGET_UNIT2_TYPE_CD
, PST2.SHARED_TYPE_NAME BUDGET_MEASUREMENT_TYPE2
, BGT.BUDGET_UNIT2_AGGREGATE BUDGET_UNIT2_AGGREGATE
, HR_GENERAL.DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE'
, BGT.BUDGET_UNIT2_AGGREGATE) BUDGET_UNIT_AGGREGATE_DESC2
, BGT.BUDGET_UNIT3_ID BUDGET_UNIT3_ID
, PST3.SYSTEM_TYPE_CD BUDGET_UNIT3_TYPE_CD
, PST3.SHARED_TYPE_NAME BUDGET_MEASUREMENT_TYPE3
, BGT.BUDGET_UNIT3_AGGREGATE BUDGET_UNIT3_AGGREGATE
, HR_GENERAL.DECODE_LOOKUP('PQH_BGT_UOM_AGGREGATE'
, BGT.BUDGET_UNIT3_AGGREGATE) BUDGET_UNIT_AGGREGATE_DESC3
, BGT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BVR.BUDGET_VERSION_ID BUDGET_VERSION_ID
, BVR.VERSION_NUMBER BUDGET_VERSION_NUMBER
, BVR.DATE_FROM BUDGET_VERSION_START_DATE
, BVR.DATE_TO BUDGET_VERSION_END_DATE
, BVR.BUDGET_UNIT1_VALUE BUDGET_UNIT1_VALUE
, BVR.BUDGET_UNIT2_VALUE BUDGET_UNIT2_VALUE
, BVR.BUDGET_UNIT3_VALUE BUDGET_UNIT3_VALUE
, BVR.BUDGET_UNIT1_AVAILABLE BUDGET_UNIT1_AVAILABLE
, BVR.BUDGET_UNIT2_AVAILABLE BUDGET_UNIT2_AVAILABLE
, BVR.BUDGET_UNIT3_AVAILABLE BUDGET_UNIT3_AVAILABLE
, BVR.GL_STATUS BUDGET_VERSION_GL_STATUS
, WDT.WORKSHEET_DETAIL_ID WORKSHEET_DETAIL_ID
, WDT.BUDGET_DETAIL_ID BUDGET_DETAIL_ID
, WDT.BUDGET_UNIT1_VALUE_TYPE_CD POSITION_UNIT1_VALUE_TYPE_CD
, WDT.BUDGET_UNIT2_VALUE_TYPE_CD POSITION_UNIT2_VALUE_TYPE_CD
, WDT.BUDGET_UNIT3_VALUE_TYPE_CD POSITION_UNIT3_VALUE_TYPE_CD
, WDT.BUDGET_UNIT1_VALUE POSITION_UNIT1_VALUE
, WDT.BUDGET_UNIT2_VALUE POSITION_UNIT2_VALUE
, WDT.BUDGET_UNIT3_VALUE POSITION_UNIT3_VALUE
, WDT.BUDGET_UNIT1_AVAILABLE POSITION_UNIT1_AVAILABLE
, WDT.BUDGET_UNIT2_AVAILABLE POSITION_UNIT2_AVAILABLE
, WDT.BUDGET_UNIT3_AVAILABLE POSITION_UNIT3_AVAILABLE
, WDT.BUDGET_UNIT1_PERCENT POSITION_UNIT1_PERCENT
, WDT.BUDGET_UNIT2_PERCENT POSITION_UNIT2_PERCENT
, WDT.BUDGET_UNIT3_PERCENT POSITION_UNIT3_PERCENT
, WDT.OLD_UNIT1_VALUE OLD_UNIT1_VALUE
, WDT.OLD_UNIT2_VALUE OLD_UNIT2_VALUE
, WDT.OLD_UNIT3_VALUE OLD_UNIT3_VALUE
, WDT.ACTION_CD ACTION_CD
, WDT.POSITION_TRANSACTION_ID POSITION_TRANSACTION_ID
, WDT.POSITION_ID POSITION_ID
, WDT.ORGANIZATION_ID ORGANIZATION_ID
, WDT.JOB_ID JOB_ID
, WDT.GRADE_ID GRADE_ID
, WDT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, WDT.LAST_UPDATED_BY LAST_UPDATED_BY
, WDT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, WDT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, WDT.CREATED_BY CREATED_BY
, WDT.CREATION_DATE CREATION_DATE
, BGT.DFLT_BUDGET_SET_ID DFLT_BUDGET_SET_ID
, DBS.DFLT_BUDGET_SET_NAME DFLT_BUDGET_SET_NAME
FROM PQH_BUDGETS BGT
, PQH_BUDGET_VERSIONS BVR
, PQH_WORKSHEET_DETAILS WDT
, FND_SESSIONS SES
, PQH_DFLT_BUDGET_SETS DBS
, PER_SHARED_TYPES_VL PST1
, PER_SHARED_TYPES_VL PST2
, PER_SHARED_TYPES_VL PST3
, PQH_WORKSHEETS WRK
WHERE BGT.BUDGET_ID = BVR.BUDGET_ID
AND BVR.BUDGET_VERSION_ID = WRK.BUDGET_VERSION_ID
AND WRK.WORKSHEET_ID = WDT.WORKSHEET_ID
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN BVR.DATE_FROM
AND NVL(BVR.DATE_TO
, HR_GENERAL.END_OF_TIME)
AND BGT.DFLT_BUDGET_SET_ID = DBS.DFLT_BUDGET_SET_ID(+)
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.BUDGETED_ENTITY_CD='POSITION'
AND WRK.BUDGET_ID = WRK.BUDGET_ID
AND WRK.WORKSHEET_MODE_CD = 'O'