[Home] [Help]
View: BOM_ORG_SHIFT_DATES_VIEW
Product: | BOM - Bills of Material |
Description: | Shift dates for an organization's calendar - used in Calendar window |
Implementation/DBA Data: |
APPS.BOM_ORG_SHIFT_DATES_VIEW
|
View Text
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
Columns
Name |
ORGANIZATION_ID |
SHIFT_NUM |
SHIFT_DATE |
SEQ_NUM |
PRIOR_SEQ_NUM |
PRIOR_DATE |
NEXT_SEQ_NUM |
NEXT_DATE |