VIEW: APPS.PSBBV_BUDGET_WORKSHEETS

Source

View Text - Preformatted

SELECT WS.NAME ,'_LA:worksheet_type:FND_LOOKUPS:PSB_WORKSHEET_TYPES:meaning' ,WS.DESCRIPTION ,WS.CURRENT_STAGE_SEQ ,WS.BUDGET_BY_POSITION ,WS.NUM_PROPOSED_YEARS ,WS.NUM_YEARS_TO_ALLOCATE ,WS.ROUNDING_FACTOR ,WS.GL_CUTOFF_PERIOD ,WS.USE_REVISED_ELEMENT_RATES ,WS.INCLUDE_TRANSLATED_BALANCE ,WS.INCLUDE_ADJUSTMENT_PERIODS ,WS.INCLUDE_STAT_BALANCE ,WS.DATE_SUBMITTED ,WS.SUBMITTED_BY ,WS.WORKSHEET_ID ,WS.BUDGET_GROUP_ID ,WS.BUDGET_CALENDAR_ID ,WS.STAGE_SET_ID ,WS.GLOBAL_WORKSHEET_ID ,WS.GL_BUDGET_SET_ID ,WS.BUDGET_VERSION_ID ,WS.DATA_EXTRACT_ID ,WS.PARAMETER_SET_ID ,WS.CONSTRAINT_SET_ID ,WS.ALLOCRULE_SET_ID ,WS.FREEZE_FLAG ,WS.LAST_UPDATED_BY ,WS.LAST_UPDATE_DATE ,WS.CREATION_DATE ,WS.CREATED_BY FROM PSB_WORKSHEETS WS WHERE 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 ) with read only

View Text - HTML Formatted

SELECT WS.NAME
, '_LA:WORKSHEET_TYPE:FND_LOOKUPS:PSB_WORKSHEET_TYPES:MEANING'
, WS.DESCRIPTION
, WS.CURRENT_STAGE_SEQ
, WS.BUDGET_BY_POSITION
, WS.NUM_PROPOSED_YEARS
, WS.NUM_YEARS_TO_ALLOCATE
, WS.ROUNDING_FACTOR
, WS.GL_CUTOFF_PERIOD
, WS.USE_REVISED_ELEMENT_RATES
, WS.INCLUDE_TRANSLATED_BALANCE
, WS.INCLUDE_ADJUSTMENT_PERIODS
, WS.INCLUDE_STAT_BALANCE
, WS.DATE_SUBMITTED
, WS.SUBMITTED_BY
, WS.WORKSHEET_ID
, WS.BUDGET_GROUP_ID
, WS.BUDGET_CALENDAR_ID
, WS.STAGE_SET_ID
, WS.GLOBAL_WORKSHEET_ID
, WS.GL_BUDGET_SET_ID
, WS.BUDGET_VERSION_ID
, WS.DATA_EXTRACT_ID
, WS.PARAMETER_SET_ID
, WS.CONSTRAINT_SET_ID
, WS.ALLOCRULE_SET_ID
, WS.FREEZE_FLAG
, WS.LAST_UPDATED_BY
, WS.LAST_UPDATE_DATE
, WS.CREATION_DATE
, WS.CREATED_BY
FROM PSB_WORKSHEETS WS
WHERE 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 ) WITH READ ONLY