FND Design Data [Home] [Help]

View: RG_SRS_DSS_DOP_V

Product: RG - Application Report Generator
Description: 10SC ONLY
Implementation/DBA Data: ViewAPPS.RG_SRS_DSS_DOP_V
View Text

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'

Columns

Name
DAY_NUM
DAY_CHAR