APPS.BOM_COPY_ROUTING dependencies on WIP_DISCRETE_JOBS

Line 2091: FROM wip_discrete_jobs job,

2087: AND primary_item_id = p_ass_itm_id
2088: AND alternate_routing_designator = p_alt_rtg_desg)
2089: OR EXISTS (
2090: SELECT 1 /* Check for WIP Jobs on primary */
2091: FROM wip_discrete_jobs job,
2092: bom_operational_routings bor
2093: WHERE job.organization_id = p_org_id
2094: AND job.primary_item_id = p_ass_itm_id
2095: AND job.alternate_routing_designator IS NULL)

Line 2098: FROM wip_discrete_jobs job,

2094: AND job.primary_item_id = p_ass_itm_id
2095: AND job.alternate_routing_designator IS NULL)
2096: OR EXISTS (
2097: SELECT 1 /* Check for WIP Jobs on alternate */
2098: FROM wip_discrete_jobs job,
2099: bom_operational_routings bor
2100: WHERE job.organization_id = p_org_id
2101: AND job.primary_item_id = p_ass_itm_id
2102: AND job.alternate_routing_designator = p_alt_rtg_desg);