[Home] [Help]
View: MRP_AP_CALENDAR_SHIFTS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT X.CALENDAR_CODE
, X.SHIFT_NUM
, X.DAYS_ON
, X.DAYS_OFF
, X.DESCRIPTION
, X.RN RN3
, Y.RN2 RN2
, Y.RN1 RN1
FROM MRP_AP_CLDR_SHFTS_SN X
, ( SELECT CALENDAR_CODE
, MAX(MTLP.RN) RN2
, MAX(MP.RN) RN1
FROM MRP_AP_MTL_PARAS_SN MTLP
, MRP_AP_MRP_PARAS_SN MP
WHERE MTLP.ORGANIZATION_ID= MP.ORGANIZATION_ID GROUP BY CALENDAR_CODE) Y
WHERE X.CALENDAR_CODE= Y.CALENDAR_CODE
Columns
Name |
CALENDAR_CODE |
SHIFT_NUM |
DAYS_ON |
DAYS_OFF |
DESCRIPTION |
RN3 |
RN2 |
RN1 |