VIEW: APPS.RG_SRS_DSS_DOP_V

Source

View Text - Preformatted

SELECT multiplier day_num, substr(to_char(multiplier),1,30) day_char from gl_row_multipliers WHERE multiplier <=35 union select -1, meaning from gl_lookups where lookup_type='LITERAL' and lookup_code='LAST' union select 100,meaning from gl_lookups where lookup_type='LITERAL' and lookup_code='N/A'

View Text - HTML Formatted

SELECT MULTIPLIER DAY_NUM
, SUBSTR(TO_CHAR(MULTIPLIER)
, 1
, 30) DAY_CHAR
FROM GL_ROW_MULTIPLIERS
WHERE MULTIPLIER <=35 UNION SELECT -1
, MEANING
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE='LITERAL'
AND LOOKUP_CODE='LAST' UNION SELECT 100
, MEANING
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE='LITERAL'
AND LOOKUP_CODE='N/A'