[Home] [Help]
View: MRP_I2_AGGREGATE_RESOURCE_V
| Product: | MRP - Master Scheduling/MRP |
|---|
| Description: | A Rhythm view supporting information regarding aggregate resources |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT SUBSTR( AGG.DEPARTMENT_CODE || MRP_I2_ERP.GET_PARAMETER( 'MRP_I2_P_DELIMITER'
, AGG.ORGANIZATION_ID) || AGG.RESOURCE_CODE
, 1
, 240)
, SUBSTR( SUB.DEPARTMENT_CODE || MRP_I2_ERP.GET_PARAMETER( 'MRP_I2_P_DELIMITER'
, SUB.ORGANIZATION_ID) || SUB.RESOURCE_CODE
, 1
, 240)
, AGG.ORGANIZATION_ID
, AGG.RESOURCE_ID
, SUB.RESOURCE_ID
, SUB.DEPARTMENT_ID
FROM MRP_RHX_BOM_DEPT_RESOURCES_V SUB
, MRP_RHX_BOM_DEPT_RESOURCES_V AGG
WHERE SUB.SHARE_CAPACITY_FLAG = 2
AND AGG.SHARE_CAPACITY_FLAG = 2
AND SUB.SHARE_FROM_DEPT_ID IS NULL
AND AGG.SHARE_FROM_DEPT_ID IS NULL
AND AGG.ORGANIZATION_ID = SUB.ORGANIZATION_ID
AND AGG.DEPARTMENT_ID = SUB.DEPARTMENT_ID
AND DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER( 'MRP_I2_P_AGG_RES_ATTR_NUM'
, SUB.ORGANIZATION_ID))
, 1
, SUB.ATTRIBUTE1
, 2
, SUB.ATTRIBUTE2
, 3
, SUB.ATTRIBUTE3
, 4
, SUB.ATTRIBUTE4
, 5
, SUB.ATTRIBUTE5
, 6
, SUB.ATTRIBUTE6
, 7
, SUB.ATTRIBUTE7
, 8
, SUB.ATTRIBUTE8
, 9
, SUB.ATTRIBUTE9
, 10
, SUB.ATTRIBUTE10
, 11
, SUB.ATTRIBUTE11
, 12
, SUB.ATTRIBUTE12
, 13
, SUB.ATTRIBUTE13
, 14
, SUB.ATTRIBUTE14
, 15
, SUB.ATTRIBUTE15) = TO_CHAR(AGG.RESOURCE_ID)
Columns
| Name |
| AGGREGATE_RESOURCE |
| SUB_RESOURCE |
| ORGANIZATION_ID |
| AGGREGATE_RESOURCE_ID |
| SUB_RESOURCE_ID |
| DEPARTMENT_ID |