View: PSB_WS_SERVICE_PACKAGES_V

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSB_WS_SERVICE_PACKAGES_V

View Text

SELECT SP.ROWID
, WS.WORKSHEET_ID
, SP.SERVICE_PACKAGE_ID
, SP.NAME
, SP.SHORT_NAME
, SP.BASE_SERVICE_PACKAGE
, SP.PRIORITY
, SP.DESCRIPTION
FROM PSB_SERVICE_PACKAGES SP
, PSB_WORKSHEETS WS
WHERE SP.GLOBAL_WORKSHEET_ID = DECODE(WS.GLOBAL_WORKSHEET_FLAG
, 'Y'
, WS.WORKSHEET_ID
, WS.GLOBAL_WORKSHEET_ID)
AND SP.BASE_SERVICE_PACKAGE = 'Y' OR ( SP.BASE_SERVICE_PACKAGE = 'N'
AND EXISTS ( SELECT 1
FROM PSB_WS_LINES LINES
, PSB_WS_ACCOUNT_LINES ACCTS
WHERE LINES.ACCOUNT_LINE_ID = ACCTS.ACCOUNT_LINE_ID
AND LINES.WORKSHEET_ID = WS.WORKSHEET_ID
AND LINES.VIEW_LINE_FLAG = 'Y'
AND ACCTS.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID
AND EXISTS ( SELECT 1
FROM PSB_BUDGET_PERIODS BP
, PSB_BUDGET_YEAR_TYPES BT
WHERE BT.YEAR_CATEGORY_TYPE <> 'PY'
AND BP.BUDGET_YEAR_TYPE_ID = BT.BUDGET_YEAR_TYPE_ID
AND BP.BUDGET_CALENDAR_ID = ( SELECT WS2.BUDGET_CALENDAR_ID
FROM PSB_WORKSHEETS WS2
WHERE WS2.WORKSHEET_ID = SP.GLOBAL_WORKSHEET_ID )
AND BP.BUDGET_PERIOD_ID = ACCTS.BUDGET_YEAR_ID ) ) )

Columns