VIEW: APPS.BIS_TOTAL_JOBS_V

Source

View Text - Preformatted

SELECT '-1' , dl.dimension_level_name from bisbv_dimension_levels dl WHERE dl.DIMENSION_LEVEL_SHORT_NAME = 'TOTAL JOBS'

View Text - HTML Formatted

SELECT '-1'
, DL.DIMENSION_LEVEL_NAME
FROM BISBV_DIMENSION_LEVELS DL
WHERE DL.DIMENSION_LEVEL_SHORT_NAME = 'TOTAL JOBS'