Skip to content FND Design Data [Home] [Help]

View: RHX_DP_L_WEEKS_V

Product: MRP - Master Scheduling/MRP
Description: - Retrofitted
Implementation/DBA Data: Not implemented in this database
View Text

SELECT DISTINCT RDT.CALENDAR_CODE
, 'W'||RDT.WEEK||'_M'||RDT.MONTH||'_Q'||RDT.QUARTER||'_'||RDT.YEAR
, RDT.WEEK_START_DATE
, RDT.WEEK_END_DATE
, RDT.EXCEPTION_SET_ID
, 'M'||RDT.MONTH||'_Q'||RDT.QUARTER||'_'||RDT.YEAR
, RDT.SEQ_NUM
FROM RHX_DP_TIMES RDT
WHERE 1=1

Columns

Name
CALENDAR_CODE
WEEK
START_DATE
END_DATE
EXCEPTION_SET_ID
MONTH
SEQ_NUM