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.

APPS.AHL_PRD_UTIL_PKG dependencies on AHL_WORK_ASSIGNMENTS

Line 744: AHL_WORK_ASSIGNMENTS WASS,

740: SELECT
741: WREQ.operation_sequence,
742: WREQ.resource_sequence
743: FROM
744: AHL_WORK_ASSIGNMENTS WASS,
745: AHL_PP_REQUIREMENT_V WREQ
746: WHERE
747: WASS.assignment_id = p_assignment_id AND
748: WREQ.resource_id = WASS.operation_resource_id AND

Line 1044: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM

1040: p_workorder_id IN NUMBER,
1041: p_operation_seq_num IN NUMBER) IS
1042: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1043: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1044: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1045: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1046: AND AOR.operation_resource_id = AWAS.operation_resource_id
1047: AND BOM.resource_id = AOR.resource_id
1048: AND BOM.resource_type = 2 -- Person

Line 1126: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM

1122: p_operation_seq_num IN NUMBER,
1123: p_resource_id IN NUMBER) IS
1124: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1125: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1126: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1127: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1128: AND AOR.operation_resource_id = AWAS.operation_resource_id
1129: AND BOM.resource_id = AOR.resource_id
1130: AND BOM.resource_type = 2 -- Person

Line 1142: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM

1138: p_operation_seq_num IN NUMBER,
1139: p_resource_id IN NUMBER) IS
1140: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1141: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1142: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1143: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1144: AND AOR.operation_resource_id = AWAS.operation_resource_id
1145: AND BOM.resource_id = AOR.resource_id
1146: AND BOM.resource_type = 2 -- Person

Line 1495: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW

1491: p_workorder_id IN NUMBER,
1492: p_operation_seq_num IN NUMBER) IS
1493: SELECT MIN(AWAS.ASSIGN_START_DATE)
1494: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1495: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1496: WHERE WOR.resource_id = AOR.resource_id
1497: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1498: AND AOR.operation_resource_id = AWAS.operation_resource_id
1499: AND WOR.wip_entity_id = AW.wip_entity_id

Line 1578: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW

1574: p_workorder_id IN NUMBER,
1575: p_operation_seq_num IN NUMBER) IS
1576: SELECT MAX(AWAS.ASSIGN_END_DATE)
1577: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1578: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1579: WHERE WOR.resource_id = AOR.resource_id
1580: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1581: AND AOR.operation_resource_id = AWAS.operation_resource_id
1582: AND WOR.wip_entity_id = AW.wip_entity_id