Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT BCD.CALENDAR_DATE
, BCD.CALENDAR_CODE
, BCD.EXCEPTION_SET_ID
, BCD.SEQ_NUM
, BCD.NEXT_SEQ_NUM
, BCD.PRIOR_SEQ_NUM
, BCD.NEXT_DATE
, BCD.PRIOR_DATE
, BC.QUARTERLY_CALENDAR_TYPE
, BC.DAYS_ON
, BC.DAYS_OFF
, BC.CALENDAR_START_DATE
, BC.CALENDAR_END_DATE
, BC.DESCRIPTION
, BC.RN RN4
, BCD.RN RN3
, Y.RN2 RN2
, Y.RN1 RN1
FROM MRP_AP_CLDRS_SN BC
, MRP_AP_CLDR_DATES_SN BCD
, ( 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 BCD.CALENDAR_CODE= BC.CALENDAR_CODE
AND BCD.CALENDAR_CODE= Y.CALENDAR_CODE
AND BCD.EXCEPTION_SET_ID= Y.CALENDAR_EXCEPTION_SET_ID