APPS.AHL_PRD_UTIL_PKG dependencies on AHL_WORKORDER_OPERATIONS

Line 435: ahl_workorder_operations

431: IS
432: SELECT
433: 'X'
434: FROM
435: ahl_workorder_operations
436: WHERE
437: workorder_id = p_workorder_id AND
438: operation_sequence_num = p_op_seq_no AND
439: status_code = 1;

Line 830: ahl_workorder_operations

826: CURSOR c_validate_op_status(p_workorder_id IN NUMBER) IS
827: SELECT
828: 'X'
829: FROM
830: ahl_workorder_operations
831: WHERE
832: workorder_id = p_workorder_id AND
833: status_code in (0,2);
834:

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 1059: AHL_WORKORDER_OPERATIONS AWOP

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
1062: AND AOR.WORKORDER_OPERATION_ID = AWOP.WORKORDER_OPERATION_ID
1063: AND AWOP.workorder_id = p_workorder_id

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 1508: FROM AHL_WORKORDER_OPERATIONS_V AO

1504: -- query to retrieve min of assigned to all employees for an operation.
1505: CURSOR c_get_op_sched_start(p_workorder_id IN NUMBER,
1506: p_operation_seq_num IN NUMBER) IS
1507: SELECT SCHEDULED_START_DATE
1508: FROM AHL_WORKORDER_OPERATIONS_V AO
1509: WHERE AO.workorder_id = p_workorder_id
1510: AND AO.operation_sequence_num = p_operation_seq_num;
1511:
1512: l_employee_id NUMBER;

Line 1591: FROM AHL_WORKORDER_OPERATIONS_V AO

1587: -- query to retrieve min of assigned to all employees for an operation.
1588: CURSOR c_get_op_sched_end(p_workorder_id IN NUMBER,
1589: p_operation_seq_num IN NUMBER) IS
1590: SELECT SCHEDULED_END_DATE
1591: FROM AHL_WORKORDER_OPERATIONS_V AO
1592: WHERE AO.workorder_id = p_workorder_id
1593: AND AO.operation_sequence_num = p_operation_seq_num;
1594:
1595: l_employee_id NUMBER;