[Home] [Help]
View: BOM_ORG_CAL_PERIODS_VIEW
View Text
SELECT MTL.ORGANIZATION_ID
, BOM.PERIOD_START_DATE
, BOM.PERIOD_SEQUENCE_NUM
, BOM.PERIOD_NAME
, BOM.NEXT_DATE
, BOM.PRIOR_DATE
FROM BOM_PERIOD_START_DATES BOM
, MTL_PARAMETERS MTL
WHERE MTL.CALENDAR_CODE = BOM.CALENDAR_CODE
AND MTL.CALENDAR_EXCEPTION_SET_ID = BOM.EXCEPTION_SET_ID
Columns
Name |
ORGANIZATION_ID |
PERIOD_START_DATE |
PERIOD_SEQUENCE_NUM |
PERIOD_NAME |
NEXT_DATE |
PRIOR_DATE |