[Home] [Help]
View: MRP_AP_CAL_YEAR_START_DATES_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT X.CALENDAR_CODE
, X.EXCEPTION_SET_ID
, X.YEAR_START_DATE
, X.RN RN3
, Y.RN2 RN2
, Y.RN1 RN1
FROM MRP_AP_CYR_SDATES_SN X
, ( SELECT CALENDAR_CODE
, CALENDAR_EXCEPTION_SET_ID
, 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
, CALENDAR_EXCEPTION_SET_ID) Y
WHERE X.CALENDAR_CODE= Y.CALENDAR_CODE
AND X.EXCEPTION_SET_ID= Y.CALENDAR_EXCEPTION_SET_ID
Columns
Name |
CALENDAR_CODE |
EXCEPTION_SET_ID |
YEAR_START_DATE |
RN3 |
RN2 |
RN1 |