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 764: AHL_WORK_ASSIGNMENTS WASS,

760: SELECT
761: WREQ.operation_sequence,
762: WREQ.resource_sequence
763: FROM
764: AHL_WORK_ASSIGNMENTS WASS,
765: AHL_PP_REQUIREMENT_V WREQ
766: WHERE
767: WASS.assignment_id = p_assignment_id AND
768: WREQ.resource_id = WASS.operation_resource_id AND

Line 1064: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM

1060: p_workorder_id IN NUMBER,
1061: p_operation_seq_num IN NUMBER) IS
1062: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1063: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1064: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1065: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1066: AND AOR.operation_resource_id = AWAS.operation_resource_id
1067: AND BOM.resource_id = AOR.resource_id
1068: AND BOM.resource_type = 2 -- Person

Line 1149: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM

1145: p_resource_id IN NUMBER,
1146: p_resource_seq_num IN NUMBER ) IS
1147: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1148: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1149: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1150: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1151: AND AOR.operation_resource_id = AWAS.operation_resource_id
1152: AND BOM.resource_id = AOR.resource_id
1153: AND BOM.resource_type = 2 -- Person

Line 1166: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM

1162: p_resource_id IN NUMBER,
1163: p_resource_seq_num IN NUMBER ) IS
1164: SELECT SUM((AWAS.assign_end_date - AWAS.assign_start_date) * 24)
1165: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,
1166: AHL_WORK_ASSIGNMENTS AWAS, BOM_RESOURCES BOM
1167: WHERE WO.workorder_operation_id = AOR.workorder_operation_id
1168: AND AOR.operation_resource_id = AWAS.operation_resource_id
1169: AND BOM.resource_id = AOR.resource_id
1170: AND BOM.resource_type = 2 -- Person

Line 1519: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW

1515: p_workorder_id IN NUMBER,
1516: p_operation_seq_num IN NUMBER) IS
1517: SELECT MIN(AWAS.ASSIGN_START_DATE)
1518: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1519: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1520: WHERE WOR.resource_id = AOR.resource_id
1521: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1522: AND AOR.operation_resource_id = AWAS.operation_resource_id
1523: AND WOR.wip_entity_id = AW.wip_entity_id

Line 1602: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW

1598: p_workorder_id IN NUMBER,
1599: p_operation_seq_num IN NUMBER) IS
1600: SELECT MAX(AWAS.ASSIGN_END_DATE)
1601: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1602: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1603: WHERE WOR.resource_id = AOR.resource_id
1604: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1605: AND AOR.operation_resource_id = AWAS.operation_resource_id
1606: AND WOR.wip_entity_id = AW.wip_entity_id