[Home] [Help]
View: BOMFV_MFG_RESOURCE_SHIFTS
View Text
SELECT SH.SHIFT_NUM SHIFT_NUMBER
, RE.RESOURCE_CODE
, DE.DEPARTMENT_CODE
, '_DF:BOM:BOM_RESOURCE_SHIFTS:SH'
, SH.RESOURCE_ID
, SH.DEPARTMENT_ID
, SH.LAST_UPDATE_DATE UPDATED_ON
, SH.LAST_UPDATED_BY UPDATED_BY
, SH.CREATION_DATE CREATED_ON
, SH.CREATED_BY CREATED_BY
FROM BOM_DEPARTMENTS DE
, BOM_RESOURCES RE
, BOM_RESOURCE_SHIFTS SH
WHERE SH.DEPARTMENT_ID = DE.DEPARTMENT_ID
AND SH.RESOURCE_ID = RE.RESOURCE_ID WITH READ ONLY
Columns
| Name |
| SHIFT_NUMBER |
| RESOURCE_CODE |
| DEPARTMENT_CODE |
| "_DF" |
| RESOURCE_ID |
| DEPARTMENT_ID |
| UPDATED_ON |
| UPDATED_BY |
| CREATED_ON |
| CREATED_BY |
APPS.BOMFV_MFG_RESOURCE_SHIFTS