DBA Data[Home] [Help]

APPS.BOM_COPY_ROUTING dependencies on WIP_DISCRETE_JOBS

Line 2155: FROM wip_discrete_jobs job --modified for bug 10431513

2151: AND primary_item_id = p_ass_itm_id
2152: AND alternate_routing_designator = p_alt_rtg_desg)
2153: OR EXISTS (
2154: SELECT 1 /* Check for WIP Jobs on primary */
2155: FROM wip_discrete_jobs job --modified for bug 10431513
2156: --bom_operational_routings bor
2157: WHERE job.organization_id = p_org_id
2158: AND job.primary_item_id = p_ass_itm_id
2159: AND job.alternate_routing_designator IS NULL)

Line 2162: FROM wip_discrete_jobs job --modified for bug 10431513

2158: AND job.primary_item_id = p_ass_itm_id
2159: AND job.alternate_routing_designator IS NULL)
2160: OR EXISTS (
2161: SELECT 1 /* Check for WIP Jobs on alternate */
2162: FROM wip_discrete_jobs job --modified for bug 10431513
2163: --bom_operational_routings bor
2164: WHERE job.organization_id = p_org_id
2165: AND job.primary_item_id = p_ass_itm_id
2166: AND job.alternate_routing_designator = p_alt_rtg_desg);