APPS.QA_PLAN_ELEMENT_API dependencies on WIP_OPERATIONS_ALL_V

Line 2309: FROM wip_operations_all_v

2305: RETURN BOOLEAN IS
2306:
2307: CURSOR c1 IS
2308: SELECT 1
2309: FROM wip_operations_all_v
2310: WHERE organization_id = x_org_id
2311: AND wip_entity_id = x_wip_entity_id
2312: AND operation_seq_num = x_op_seq_number;
2313:

Line 2316: FROM wip_operations_all_v

2312: AND operation_seq_num = x_op_seq_number;
2313:
2314: CURSOR c2 IS
2315: SELECT 1
2316: FROM wip_operations_all_v
2317: WHERE organization_id = x_org_id
2318: AND wip_entity_id = x_wip_entity_id
2319: AND operation_seq_num = x_op_seq_number
2320: AND repetitive_schedule_id =

Line 2364: FROM wip_operations_all_v

2360: RETURN BOOLEAN IS
2361:
2362: CURSOR c IS
2363: SELECT 1
2364: FROM wip_operations_all_v
2365: WHERE organization_id = x_org_id
2366: AND wip_entity_id = x_maintenance_work_order_id
2367: AND operation_seq_num = x_maintenance_op_seq;
2368:

Line 3696: FROM wip_operations_all_v

3692:
3693: IF (x_line_id IS NULL) THEN
3694:
3695: sql_string := 'SELECT operation_seq_num, operation_code
3696: FROM wip_operations_all_v
3697: WHERE operation_seq_num like :1
3698: AND wip_entity_id = :2
3699: AND organization_id = :3
3700: ORDER BY operation_seq_num';

Line 3707: FROM wip_operations_all_v

3703:
3704: ELSE
3705:
3706: sql_string := 'SELECT operation_seq_num, operation_code
3707: FROM wip_operations_all_v
3708: WHERE operation_seq_num like :1
3709: AND wip_entity_id = :2
3710: AND organization_id = :3
3711: AND repetitive_schedule_id =

Line 3758: FROM wip_operations_all_v

3754:
3755: x_wip_entity_id := get_job_id(org_id, maintenance_work_order);
3756:
3757: sql_string := 'SELECT operation_seq_num, operation_code
3758: FROM wip_operations_all_v
3759: WHERE operation_seq_num like :1
3760: AND wip_entity_id = :2
3761: AND organization_id = :3
3762: ORDER BY operation_seq_num';