APPS.QA_PLAN_ELEMENT_API dependencies on WIP_OPERATIONS_ALL_V

Line 2290: FROM wip_operations_all_v

2286: RETURN BOOLEAN IS
2287:
2288: CURSOR c1 IS
2289: SELECT 1
2290: FROM wip_operations_all_v
2291: WHERE organization_id = x_org_id
2292: AND wip_entity_id = x_wip_entity_id
2293: AND operation_seq_num = x_op_seq_number;
2294:

Line 2297: FROM wip_operations_all_v

2293: AND operation_seq_num = x_op_seq_number;
2294:
2295: CURSOR c2 IS
2296: SELECT 1
2297: FROM wip_operations_all_v
2298: WHERE organization_id = x_org_id
2299: AND wip_entity_id = x_wip_entity_id
2300: AND operation_seq_num = x_op_seq_number
2301: AND repetitive_schedule_id =

Line 2345: FROM wip_operations_all_v

2341: RETURN BOOLEAN IS
2342:
2343: CURSOR c IS
2344: SELECT 1
2345: FROM wip_operations_all_v
2346: WHERE organization_id = x_org_id
2347: AND wip_entity_id = x_maintenance_work_order_id
2348: AND operation_seq_num = x_maintenance_op_seq;
2349:

Line 3604: FROM wip_operations_all_v

3600:
3601: IF (x_line_id IS NULL) THEN
3602:
3603: sql_string := 'SELECT operation_seq_num, operation_code
3604: FROM wip_operations_all_v
3605: WHERE operation_seq_num like :1
3606: AND wip_entity_id = :2
3607: AND organization_id = :3
3608: ORDER BY operation_seq_num';

Line 3615: FROM wip_operations_all_v

3611:
3612: ELSE
3613:
3614: sql_string := 'SELECT operation_seq_num, operation_code
3615: FROM wip_operations_all_v
3616: WHERE operation_seq_num like :1
3617: AND wip_entity_id = :2
3618: AND organization_id = :3
3619: AND repetitive_schedule_id =

Line 3666: FROM wip_operations_all_v

3662:
3663: x_wip_entity_id := get_job_id(org_id, maintenance_work_order);
3664:
3665: sql_string := 'SELECT operation_seq_num, operation_code
3666: FROM wip_operations_all_v
3667: WHERE operation_seq_num like :1
3668: AND wip_entity_id = :2
3669: AND organization_id = :3
3670: ORDER BY operation_seq_num';