VIEW: APPS.PSB_WS_SERVICE_PACKAGES_V

Source

View Text - Preformatted

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 ) ) )

View Text - HTML Formatted

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 ) ) )