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]

APPS.AHL_PRD_UTIL_PKG dependencies on AHL_OPERATION_RESOURCES

Line 1043: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,

1039: CURSOR c_get_total_hours_emp(p_employee_id IN NUMBER,
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

Line 1057: FROM AHL_OPERATION_RESOURCES AOR,

1053: -- query to retrieve total hrs required for all employees for an operation.
1054: CURSOR c_get_total_hours_op(p_workorder_id IN NUMBER,
1055: p_operation_seq_num IN NUMBER) IS
1056: SELECT SUM(NVL(AOR.duration, 0))
1057: FROM AHL_OPERATION_RESOURCES AOR,
1058: BOM_RESOURCES BOMR,
1059: AHL_WORKORDER_OPERATIONS AWOP
1060: WHERE AOR.RESOURCE_ID = BOMR.RESOURCE_ID
1061: AND BOMR.resource_type = 2 -- Person

Line 1125: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,

1121: p_workorder_id IN NUMBER,
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

Line 1141: FROM AHL_WORKORDER_OPERATIONS WO, AHL_OPERATION_RESOURCES AOR,

1137: CURSOR c_get_total_hours_op(p_workorder_id IN NUMBER,
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

Line 1494: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,

1490: CURSOR c_get_assigned_start_emp(p_employee_id IN NUMBER,
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

Line 1577: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,

1573: CURSOR c_get_assigned_end_emp(p_employee_id IN NUMBER,
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