eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MRP_I2_RESOURCE_V

Product:	MRP - Master Scheduling/MRP
Description:	A Rhythm view supporting information regarding resources planned by Rhythm
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SUBSTR( BR.DEPARTMENT_CODE || MRP_I2_ERP.GET_PARAMETER( 'MRP_I2_P_DELIMITER'
, BR.ORGANIZATION_ID) || BR.RESOURCE_CODE
, 1
, 240)
, BR.DEPARTMENT_CODE
, BR.DESCRIPTION
, BR.CAPACITY_UNITS
, DECODE(BR.AVAILABLE_24_HOURS_FLAG
, 1
, 'Y'
, 'N')
, BR.UNIT_OF_MEASURE
, BR.RESOURCE_ID
, BR.DEPARTMENT_ID
, 'N'
, BR.SHARE_FROM_DEPT_ID
, BR.ORGANIZATION_ID
, MFG.MEANING
, MFG.LOOKUP_CODE
, TO_NUMBER(DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_RES_MQT_ATTR_NUM'
, BR.ORGANIZATION_ID))
, 1
, BR.ATTRIBUTE1
, 2
, BR.ATTRIBUTE2
, 3
, BR.ATTRIBUTE3
, 4
, BR.ATTRIBUTE4
, 5
, BR.ATTRIBUTE5
, 6
, BR.ATTRIBUTE6
, 7
, BR.ATTRIBUTE7
, 8
, BR.ATTRIBUTE8
, 9
, BR.ATTRIBUTE9
, 10
, BR.ATTRIBUTE10
, 11
, BR.ATTRIBUTE11
, 12
, BR.ATTRIBUTE12
, 13
, BR.ATTRIBUTE13
, 14
, BR.ATTRIBUTE14
, 15
, BR.ATTRIBUTE15))
, TO_NUMBER(DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_RES_EQT_ATTR_NUM'
, BR.ORGANIZATION_ID))
, 1
, BR.ATTRIBUTE1
, 2
, BR.ATTRIBUTE2
, 3
, BR.ATTRIBUTE3
, 4
, BR.ATTRIBUTE4
, 5
, BR.ATTRIBUTE5
, 6
, BR.ATTRIBUTE6
, 7
, BR.ATTRIBUTE7
, 8
, BR.ATTRIBUTE8
, 9
, BR.ATTRIBUTE9
, 10
, BR.ATTRIBUTE10
, 11
, BR.ATTRIBUTE11
, 12
, BR.ATTRIBUTE12
, 13
, BR.ATTRIBUTE13
, 14
, BR.ATTRIBUTE14
, 15
, BR.ATTRIBUTE15))
, TO_NUMBER(DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_RES_OFFFROM_ATTR_NUM'
, BR.ORGANIZATION_ID))
, 1
, BR.ATTRIBUTE1
, 2
, BR.ATTRIBUTE2
, 3
, BR.ATTRIBUTE3
, 4
, BR.ATTRIBUTE4
, 5
, BR.ATTRIBUTE5
, 6
, BR.ATTRIBUTE6
, 7
, BR.ATTRIBUTE7
, 8
, BR.ATTRIBUTE8
, 9
, BR.ATTRIBUTE9
, 10
, BR.ATTRIBUTE10
, 11
, BR.ATTRIBUTE11
, 12
, BR.ATTRIBUTE12
, 13
, BR.ATTRIBUTE13
, 14
, BR.ATTRIBUTE14
, 15
, BR.ATTRIBUTE15))
, TO_NUMBER(DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_RES_OFFTO_ATTR_NUM'
, BR.ORGANIZATION_ID))
, 1
, BR.ATTRIBUTE1
, 2
, BR.ATTRIBUTE2
, 3
, BR.ATTRIBUTE3
, 4
, BR.ATTRIBUTE4
, 5
, BR.ATTRIBUTE5
, 6
, BR.ATTRIBUTE6
, 7
, BR.ATTRIBUTE7
, 8
, BR.ATTRIBUTE8
, 9
, BR.ATTRIBUTE9
, 10
, BR.ATTRIBUTE10
, 11
, BR.ATTRIBUTE11
, 12
, BR.ATTRIBUTE12
, 13
, BR.ATTRIBUTE13
, 14
, BR.ATTRIBUTE14
, 15
, BR.ATTRIBUTE15))
FROM MRP_RHX_BOM_DEPT_RESOURCES_V BR
, MFG_LOOKUPS MFG
WHERE BR.SHARE_CAPACITY_FLAG = 2
AND BR.SHARE_FROM_DEPT_ID IS NULL
AND MFG.LOOKUP_TYPE='BOM_AGGREGATE_RESOURCE_TYPE'
AND MFG.LOOKUP_CODE = MRP_I2_INT.AGGREGATE_OR_SUB_RESOURCE( BR.DEPARTMENT_ID
, BR.RESOURCE_ID
, TO_NUMBER(DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER( 'MRP_I2_P_AGG_RES_ATTR_NUM'
, BR.ORGANIZATION_ID))
, 1
, BR.ATTRIBUTE1
, 2
, BR.ATTRIBUTE2
, 3
, BR.ATTRIBUTE3
, 4
, BR.ATTRIBUTE4
, 5
, BR.ATTRIBUTE5
, 6
, BR.ATTRIBUTE6
, 7
, BR.ATTRIBUTE7
, 8
, BR.ATTRIBUTE8
, 9
, BR.ATTRIBUTE9
, 10
, BR.ATTRIBUTE10
, 11
, BR.ATTRIBUTE11
, 12
, BR.ATTRIBUTE12
, 13
, BR.ATTRIBUTE13
, 14
, BR.ATTRIBUTE14
, 15
, BR.ATTRIBUTE15
, 1))
, BR.ORGANIZATION_ID) UNION ALL SELECT 'DUMMY_RES'
, 'DUMMY_LOC'
, 'DUMMY RESOURCE'
, 1
, 'Y'
, 'HR'
, -1
, -1
, 'N'
, TO_NUMBER(NULL)
, MP.ORGANIZATION_ID
, LU.MEANING
, 3
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MFG_LOOKUPS LU
, MTL_PARAMETERS MP
WHERE LU.LOOKUP_TYPE = 'BOM_AGGREGATE_RESOURCE_TYPE'
AND LU.LOOKUP_CODE = 3

Columns

Name
RESOURCE_NAME
LOCATION
DESCRIPTION
NUMBER_POOLED_RESOURCES
AVAIL_24
UNIT_OF_MEASURE
RESOURCE_ID
DEPARTMENT_ID
SHARE_CAPACITY_FLAG
SHARE_FROM_DEPT_ID
ORGANIZATION_ID
MODEL_TYPE
MODEL_TYPE_CODE
MINIMUM_QUEUE_TIME
ESTIMATED_QUEUE_TIME
OFFLOADABLE_FROM
OFFLOADABLE_TO