VIEW: APPS.PSB_WS_YEAR_PROFILES_V

Source

View Text - Preformatted

SELECT WUP.ROWID ,WUP.WORKSHEET_ID ,WUP.USER_ID ,WUP.PROFILE_TYPE ,YTP.YEAR_CATEGORY_TYPE ,YTP.NAME ,WUP.BUDGET_PERIOD_ID ,BP.NAME ,YTP.SEQUENCE_NUMBER ,WUP.FTE_FLAG ,WUP.ACTUAL_FLAG ,WUP.BUDGET_FLAG ,WUP.ESTIMATE_FLAG ,WUP.ENCUMBRANCE_FLAG ,WUP.START_YEAR_FLAG ,WUP.LAST_UPDATE_DATE ,WUP.LAST_UPDATED_BY ,WUP.LAST_UPDATE_LOGIN ,WUP.CREATED_BY ,WUP.CREATION_DATE FROM PSB_WS_USER_PROFILES WUP,PSB_BUDGET_PERIODS BP,PSB_BUDGET_YEAR_TYPES YTP WHERE WUP.BUDGET_PERIOD_ID = BP.BUDGET_PERIOD_ID(+) AND BP.BUDGET_YEAR_TYPE_ID = YTP.BUDGET_YEAR_TYPE_ID(+) AND WUP.PROFILE_TYPE = 'Y'

View Text - HTML Formatted

SELECT WUP.ROWID
, WUP.WORKSHEET_ID
, WUP.USER_ID
, WUP.PROFILE_TYPE
, YTP.YEAR_CATEGORY_TYPE
, YTP.NAME
, WUP.BUDGET_PERIOD_ID
, BP.NAME
, YTP.SEQUENCE_NUMBER
, WUP.FTE_FLAG
, WUP.ACTUAL_FLAG
, WUP.BUDGET_FLAG
, WUP.ESTIMATE_FLAG
, WUP.ENCUMBRANCE_FLAG
, WUP.START_YEAR_FLAG
, WUP.LAST_UPDATE_DATE
, WUP.LAST_UPDATED_BY
, WUP.LAST_UPDATE_LOGIN
, WUP.CREATED_BY
, WUP.CREATION_DATE
FROM PSB_WS_USER_PROFILES WUP
, PSB_BUDGET_PERIODS BP
, PSB_BUDGET_YEAR_TYPES YTP
WHERE WUP.BUDGET_PERIOD_ID = BP.BUDGET_PERIOD_ID(+)
AND BP.BUDGET_YEAR_TYPE_ID = YTP.BUDGET_YEAR_TYPE_ID(+)
AND WUP.PROFILE_TYPE = 'Y'