SELECT mtl.organization_id, bom.shift_num, bom.shift_date, bom.seq_num, bom.prior_seq_num, bom.prior_date, bom.next_seq_num, bom.next_date FROM BOM_SHIFT_DATES BOM,MTL_PARAMETERS MTL where mtl.calendar_code = bom.calendar_code and mtl.calendar_exception_set_id = bom.exception_set_id
SELECT MTL.ORGANIZATION_ID
, BOM.SHIFT_NUM
, BOM.SHIFT_DATE
, BOM.SEQ_NUM
, BOM.PRIOR_SEQ_NUM
, BOM.PRIOR_DATE
, BOM.NEXT_SEQ_NUM
, BOM.NEXT_DATE
FROM BOM_SHIFT_DATES BOM
, MTL_PARAMETERS MTL
WHERE MTL.CALENDAR_CODE = BOM.CALENDAR_CODE
AND MTL.CALENDAR_EXCEPTION_SET_ID = BOM.EXCEPTION_SET_ID
|
|
|