DBA Data[Home] [Help]

VIEW: APPS.BIS_TOTAL_TIMES_V

Source

View Text - Preformatted

SELECT '-1' ID , dl.dimension_level_name VALUE , NULL PERIOD_SET_NAME , NULL PERIOD_NAME , NULL START_DATE , NULL END_DATE , NULL PERIOD_YEAR , NULL Organization_ID , NULL Organization_Type from bisbv_dimension_levels dl WHERE dl.DIMENSION_LEVEL_SHORT_NAME = 'TOTAL_TIME'
View Text - HTML Formatted

SELECT '-1' ID
, DL.DIMENSION_LEVEL_NAME VALUE
, NULL PERIOD_SET_NAME
, NULL PERIOD_NAME
, NULL START_DATE
, NULL END_DATE
, NULL PERIOD_YEAR
, NULL ORGANIZATION_ID
, NULL ORGANIZATION_TYPE
FROM BISBV_DIMENSION_LEVELS DL
WHERE DL.DIMENSION_LEVEL_SHORT_NAME = 'TOTAL_TIME'