View: BOMFV_MFG_SHIFT_MODIFICATIONS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMFV_MFG_SHIFT_MODIFICATIONS

View Text

SELECT CH.SHIFT_NUM SHIFT_NUMBER
, RE.RESOURCE_CODE
, DE.DEPARTMENT_CODE
, CH.FROM_DATE CAPACITY_CHANGE_START_DATE
, CH.TO_DATE CAPACITY_CHANGE_END_DATE
, CH.FROM_TIME CAPACITY_CHANGE_START_TIME
, CH.TO_TIME CAPACITY_CHANGE_END_TIME
, CH.SIMULATION_SET
, '_LA:ACTION_TYPE:MFG_LOOKUPS:BOM_ACTION:MEANING'
, '_DF:BOM:BOM_RESOURCE_CHANGES:CH'
, CH.CAPACITY_CHANGE
, CH.RESOURCE_ID
, CH.DEPARTMENT_ID
, CH.LAST_UPDATE_DATE UPDATED_ON
, CH.LAST_UPDATED_BY UPDATED_BY
, CH.CREATION_DATE CREATED_ON
, CH.CREATED_BY CREATED_BY
FROM BOM_DEPARTMENTS DE
, BOM_RESOURCES RE
, BOM_RESOURCE_CHANGES CH
WHERE CH.DEPARTMENT_ID = DE.DEPARTMENT_ID
AND CH.RESOURCE_ID = RE.RESOURCE_ID WITH READ ONLY

Columns