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.

VIEW: APPS.WMS_PERSON_RESOURCE_UTT_V

Source

View Text - Preformatted


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(+)

View Text - HTML Formatted

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(+)