[Home] [Help]
View: MRP_AP_RESOURCE_CHANGES_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.FROM_DATE
, X.TO_DATE
, X.FROM_TIME
, X.TO_TIME
, X.CAPACITY_CHANGE
, X.SIMULATION_SET
, X.ACTION_TYPE
, X.RN RN2
, MP.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_DEPTS_SN DEPT
, MRP_AP_RES_CHNGS_SN X
WHERE X.DEPARTMENT_ID= DEPT.DEPARTMENT_ID
AND DEPT.ORGANIZATION_ID= MP.ORGANIZATION_ID
Columns
Name |
DEPARTMENT_ID |
RESOURCE_ID |
SHIFT_NUM |
FROM_DATE |
TO_DATE |
FROM_TIME |
TO_TIME |
CAPACITY_CHANGE |
SIMULATION_SET |
ACTION_TYPE |
RN2 |
RN1 |