VIEW: APPS.BOMBV_MFG_SHIFT_MODIFICATIONS

Source

View Text - Preformatted

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 , '_LA:ACTION_TYPE:MFG_LOOKUPS:BOM_ACTION:MEANING' , CH.SIMULATION_SET , 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

View Text - HTML Formatted

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
, '_LA:ACTION_TYPE:MFG_LOOKUPS:BOM_ACTION:MEANING'
, CH.SIMULATION_SET
, 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