[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 |