[Home] [Help]
View: MRP_AP_RESOURCE_SHIFTS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT X.DEPARTMENT_ID
, X.RESOURCE_ID
, X.SHIFT_NUM
, X.RN RN2
, MP.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_DEPTS_SN DEPT
, MRP_AP_RES_SHFTS_SN X
WHERE X.DEPARTMENT_ID= DEPT.DEPARTMENT_ID
AND DEPT.ORGANIZATION_ID= MP.ORGANIZATION_ID
Columns
Name |
DEPARTMENT_ID |
RESOURCE_ID |
SHIFT_NUM |
RN2 |
RN1 |