VIEW: APPS.PSBFV_BUDGET_WORKSHEETS

Source

View Text - Preformatted

SELECT WS.NAME, BG.NAME, BC.NAME, BS.NAME, DE.DATA_EXTRACT_NAME, PESP.NAME, PESC.NAME, PESA.NAME, '_LA:worksheet_type:FND_LOOKUPS:PSB_WORKSHEET_TYPES:meaning', WS.DESCRIPTION, WS.CURRENT_STAGE_SEQ, '_DF:PSB:PSB_WORKSHEETS:WS', WS.USE_REVISED_ELEMENT_RATES, WS.BUDGET_BY_POSITION, WS.INCLUDE_TRANSLATED_BALANCE, WS.INCLUDE_ADJUSTMENT_PERIODS, WS.INCLUDE_STAT_BALANCE, WS.NUM_PROPOSED_YEARS, WS.NUM_YEARS_TO_ALLOCATE, WS.GL_CUTOFF_PERIOD, WS.ROUNDING_FACTOR, GLV.BUDGET_NAME, GLS.GL_BUDGET_SET_NAME, WS.DATE_SUBMITTED, WS.SUBMITTED_BY, WS.FREEZE_FLAG, WS.WORKSHEET_ID, WS.BUDGET_GROUP_ID, WS.BUDGET_CALENDAR_ID, WS.STAGE_SET_ID, WS.GLOBAL_WORKSHEET_ID, WS.BUDGET_VERSION_ID, WS.GL_BUDGET_SET_ID, WS.DATA_EXTRACT_ID, WS.PARAMETER_SET_ID, WS.CONSTRAINT_SET_ID, WS.ALLOCRULE_SET_ID, WS.LAST_UPDATE_DATE, WS.LAST_UPDATED_BY, WS.CREATED_BY, WS.CREATION_DATE FROM PSB_BUDGET_GROUPS BG, PSB_WORKSHEETS WS, PSB_BUDGET_CALENDARS BC, PSB_BUDGET_STAGES BS, PSB_DATA_EXTRACTS DE, PSB_ENTITY_SET PESP, PSB_ENTITY_SET PESC, PSB_ENTITY_SET PESA, GL_BUDGET_VERSIONS GLV, PSB_GL_BUDGET_SETS GLS WHERE WS.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID AND WS.BUDGET_CALENDAR_ID = BC.BUDGET_CALENDAR_ID AND WS.budget_group_id in ( select budget_group_id from PSB_BUDGET_GROUPS where budget_group_type = 'R' and sysdate between effective_start_date and nvl(effective_end_date,sysdate) start with budget_group_id in (select budget_group_id from PSB_BUDGET_GROUP_RESP where responsibility_id = FND_GLOBAL.RESP_ID) connect by prior budget_group_id = parent_budget_group_id ) AND WS.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID(+) AND WS.STAGE_SET_ID = BS.BUDGET_STAGE_SET_ID AND WS.CURRENT_STAGE_SEQ = BS.SEQUENCE_NUMBER AND WS.PARAMETER_SET_ID = PESP.ENTITY_SET_ID(+) AND WS.CONSTRAINT_SET_ID = PESC.ENTITY_SET_ID(+) AND WS.ALLOCRULE_SET_ID = PESA.ENTITY_SET_ID(+) AND WS.BUDGET_VERSION_ID = GLV.BUDGET_VERSION_ID(+) AND WS.GL_BUDGET_SET_ID = GLS.GL_BUDGET_SET_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT WS.NAME
, BG.NAME
, BC.NAME
, BS.NAME
, DE.DATA_EXTRACT_NAME
, PESP.NAME
, PESC.NAME
, PESA.NAME
, '_LA:WORKSHEET_TYPE:FND_LOOKUPS:PSB_WORKSHEET_TYPES:MEANING'
, WS.DESCRIPTION
, WS.CURRENT_STAGE_SEQ
, '_DF:PSB:PSB_WORKSHEETS:WS'
, WS.USE_REVISED_ELEMENT_RATES
, WS.BUDGET_BY_POSITION
, WS.INCLUDE_TRANSLATED_BALANCE
, WS.INCLUDE_ADJUSTMENT_PERIODS
, WS.INCLUDE_STAT_BALANCE
, WS.NUM_PROPOSED_YEARS
, WS.NUM_YEARS_TO_ALLOCATE
, WS.GL_CUTOFF_PERIOD
, WS.ROUNDING_FACTOR
, GLV.BUDGET_NAME
, GLS.GL_BUDGET_SET_NAME
, WS.DATE_SUBMITTED
, WS.SUBMITTED_BY
, WS.FREEZE_FLAG
, WS.WORKSHEET_ID
, WS.BUDGET_GROUP_ID
, WS.BUDGET_CALENDAR_ID
, WS.STAGE_SET_ID
, WS.GLOBAL_WORKSHEET_ID
, WS.BUDGET_VERSION_ID
, WS.GL_BUDGET_SET_ID
, WS.DATA_EXTRACT_ID
, WS.PARAMETER_SET_ID
, WS.CONSTRAINT_SET_ID
, WS.ALLOCRULE_SET_ID
, WS.LAST_UPDATE_DATE
, WS.LAST_UPDATED_BY
, WS.CREATED_BY
, WS.CREATION_DATE
FROM PSB_BUDGET_GROUPS BG
, PSB_WORKSHEETS WS
, PSB_BUDGET_CALENDARS BC
, PSB_BUDGET_STAGES BS
, PSB_DATA_EXTRACTS DE
, PSB_ENTITY_SET PESP
, PSB_ENTITY_SET PESC
, PSB_ENTITY_SET PESA
, GL_BUDGET_VERSIONS GLV
, PSB_GL_BUDGET_SETS GLS
WHERE WS.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND WS.BUDGET_CALENDAR_ID = BC.BUDGET_CALENDAR_ID
AND WS.BUDGET_GROUP_ID IN ( SELECT BUDGET_GROUP_ID
FROM PSB_BUDGET_GROUPS
WHERE BUDGET_GROUP_TYPE = 'R'
AND SYSDATE BETWEEN EFFECTIVE_START_DATE
AND NVL(EFFECTIVE_END_DATE
, SYSDATE) START WITH BUDGET_GROUP_ID IN (SELECT BUDGET_GROUP_ID
FROM PSB_BUDGET_GROUP_RESP
WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID) CONNECT BY PRIOR BUDGET_GROUP_ID = PARENT_BUDGET_GROUP_ID )
AND WS.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID(+)
AND WS.STAGE_SET_ID = BS.BUDGET_STAGE_SET_ID
AND WS.CURRENT_STAGE_SEQ = BS.SEQUENCE_NUMBER
AND WS.PARAMETER_SET_ID = PESP.ENTITY_SET_ID(+)
AND WS.CONSTRAINT_SET_ID = PESC.ENTITY_SET_ID(+)
AND WS.ALLOCRULE_SET_ID = PESA.ENTITY_SET_ID(+)
AND WS.BUDGET_VERSION_ID = GLV.BUDGET_VERSION_ID(+)
AND WS.GL_BUDGET_SET_ID = GLS.GL_BUDGET_SET_ID (+) WITH READ ONLY