[Home] [Help]
View: MRP_I2_RESOURCE_CALENDAR_V
| Product: | MRP - Master Scheduling/MRP |
|---|
| Description: | A Rhythm view supporting information regarding the availability of resources |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT SUBSTR( BRC.DEPARTMENT_CODE || MRP_I2_ERP.GET_PARAMETER( 'MRP_I2_P_DELIMITER'
, BRC.ORGANIZATION_ID) || BRC.RESOURCE_CODE
, 1
, 240)
, BRC.START_TIME
, BRC.END_TIME
, BRC.SHIFT_NUM
, BRC.CAPACITY_UNITS
, BRC.ORGANIZATION_ID
, BRC.RESOURCE_ID
, BRC.DEPARTMENT_ID
, BRC.SIMULATION_SET
FROM MRP_RHX_BOM_RESOURCE_CAL_V BRC
WHERE BRC.END_TIME >= TRUNC(MRP_I2_ERP.GET_START_DATE(BRC.ORGANIZATION_ID))
AND BRC.START_TIME < TRUNC(MRP_I2_ERP.GET_END_DATE(BRC.ORGANIZATION_ID)) + 1
AND BRC.SIMULATION_SET = MRP_I2_ERP.GET_PARAMETER('CAP_SIMULATION_SET'
, BRC.ORGANIZATION_ID)
Columns
| Name |
| RESOURCE_NAME |
| START_TIME |
| END_TIME |
| SHIFT_NUM |
| NUMBER_POOLED_RESOURCES |
| ORGANIZATION_ID |
| RESOURCE_ID |
| DEPARTMENT_ID |
| SIMULATION_SET |