View: WMS_PERSON_RESOURCE_UTT_V

Product:	WMS - Warehouse Management
Description:	Relationship of standard_operation_id and resource instances. Used by task dispatching engine.
Implementation/DBA Data:	APPS.WMS_PERSON_RESOURCE_UTT_V

View Text

SELECT UTT_EMP.STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, UTT_EMP.RESOURCE_ID ROLE
, UTT_EQP.RESOURCE_ID EQUIPMENT
, UTT_EMP.PERSON_ID EMP_ID
, UTT_EQP.INVENTORY_ITEM_ID EQP_ID
, NULL EQP_SRL /* REMOVED FOR BUG 2095237 */
FROM (SELECT X_UTT_RES1.STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, X_UTT_RES1.RESOURCE_ID RESOURCE_ID
, X_EMP_R.PERSON_ID
FROM BOM_STD_OP_RESOURCES X_UTT_RES1
, BOM_RESOURCES R1
, BOM_RESOURCE_EMPLOYEES X_EMP_R
WHERE X_UTT_RES1.RESOURCE_ID = R1.RESOURCE_ID
AND R1.RESOURCE_TYPE = 2
AND X_UTT_RES1.RESOURCE_ID = X_EMP_R.RESOURCE_ID ) UTT_EMP
, (SELECT X_UTT_RES2.STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, X_UTT_RES2.RESOURCE_ID RESOURCE_ID
, X_EQP_R.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
FROM BOM_STD_OP_RESOURCES X_UTT_RES2
, BOM_RESOURCES R2
, BOM_RESOURCE_EQUIPMENTS X_EQP_R
WHERE X_UTT_RES2.RESOURCE_ID = R2.RESOURCE_ID
AND R2.RESOURCE_TYPE = 1
AND X_UTT_RES2.RESOURCE_ID = X_EQP_R.RESOURCE_ID ) UTT_EQP
WHERE UTT_EMP.STANDARD_OPERATION_ID = UTT_EQP.STANDARD_OPERATION_ID(+)

Columns