APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on WIP_DISCRETE_JOBS

Line 2428: FROM wip_discrete_jobs

2424:
2425: --to check if any open discrete jobs exist
2426: CURSOR c_dis_job IS
2427: SELECT status_type
2428: FROM wip_discrete_jobs
2429: WHERE primary_item_id = p_inventory_item_id
2430: AND organization_id = p_org_id;
2431:
2432: -- to check if any open flow schedules exist

Line 2471: --to check for open work orders in wip_discrete_jobs

2467:
2468: CLOSE c_reserv;
2469:
2470:
2471: --to check for open work orders in wip_discrete_jobs
2472:
2473: OPEN c_dis_job;
2474:
2475: LOOP