[Home] [Help]
300: IF (p_workorder_id IS NOT NULL AND
301: p_operation_sequence IS NOT NULL) THEN
302: --
303: SELECT workorder_operation_id INTO x_workorder_operation_id
304: FROM AHL_WORKORDER_OPERATIONS
305: WHERE workorder_id = p_workorder_id
306: AND operation_sequence_num = p_operation_sequence;
307: --
308: END IF;
1297: CURSOR Get_sch_dates_cur(c_wo_operation_id IN NUMBER,
1298: c_req_date IN DATE)
1299: IS
1300: SELECT 1
1301: FROM ahl_workorder_operations_v
1302: WHERE workorder_operation_id = c_wo_operation_id
1303: AND c_req_date between trunc(scheduled_start_date)
1304: and trunc(scheduled_end_date) ;
1305: -- TO Get uom code for meaning
1317: --Get operation sequnece
1318: CURSOR Get_Operation_Seq_cur(c_operation_id IN NUMBER)
1319: IS
1320: SELECT operation_sequence_num
1321: FROM ahl_workorder_operations
1322: WHERE workorder_operation_id = c_operation_id;
1323: -- sracha: added for bug# 6802777.
1324: -- derive dept. from wip-operations.
1325: CURSOR get_oper_dept(c_wip_entity_id IN NUMBER,
3864: AHL_SCHEDULE_MATERIALS ASML,
3865: wip_requirement_operations wipr,
3866: MTL_SYSTEM_ITEMS_VL MSIV,
3867: AHL_VISITS_VL AVST,
3868: AHL_WORKORDER_OPERATIONS AWOP,
3869: -- added for FP bug# 6802777
3870: WIP_OPERATIONS WOP
3871: WHERE
3872: AWOP.WORKORDER_OPERATION_ID = ASML.WORKORDER_OPERATION_ID AND