APPS.ENG_ECO_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1590: (select 'x' from bom_operational_routings

1586: UPDATE BOM_OPERATION_SEQUENCES bos
1587: SET bos.EFFECTIVITY_DATE = p_effectivity_date
1588: WHERE bos.CHANGE_NOTICE = x_change_notice
1589: AND exists
1590: (select 'x' from bom_operational_routings
1591: where routing_sequence_id = bos.routing_sequence_id
1592: and organization_id = x_organization_id )
1593: AND bos.IMPLEMENTATION_DATE IS NULL;
1594:

Line 1606: (select 'x' from bom_operational_routings

1602: SET bos1.DISABLE_DATE = p_effectivity_date
1603: WHERE bos1.CHANGE_NOTICE = x_change_notice
1604: and bos1.ACD_TYPE = 3 -- ACD Type: Disable
1605: AND exists
1606: (select 'x' from bom_operational_routings
1607: where routing_sequence_id = bos1.routing_sequence_id
1608: and organization_id = x_organization_id )
1609: AND bos1.IMPLEMENTATION_DATE IS NULL;
1610:

Line 1980: (select 'x' from bom_operational_routings

1976: UPDATE BOM_OPERATION_SEQUENCES bos
1977: SET bos.EFFECTIVITY_DATE = p_effectivity_date
1978: WHERE bos.CHANGE_NOTICE = x_change_notice
1979: AND exists
1980: (select 'x' from bom_operational_routings
1981: where routing_sequence_id = bos.routing_sequence_id
1982: and organization_id = x_organization_id )
1983: AND bos.IMPLEMENTATION_DATE IS NULL;
1984:

Line 1996: (select 'x' from bom_operational_routings

1992: SET bos1.DISABLE_DATE = p_effectivity_date
1993: WHERE bos1.CHANGE_NOTICE = x_change_notice
1994: and bos1.ACD_TYPE = 3 -- ACD Type: Disable
1995: AND exists
1996: (select 'x' from bom_operational_routings
1997: where routing_sequence_id = bos1.routing_sequence_id
1998: and organization_id = x_organization_id )
1999: AND bos1.IMPLEMENTATION_DATE IS NULL;
2000:

Line 2349: DELETE FROM BOM_OPERATIONAL_ROUTINGS bor

2345:
2346: -- Delete the bom header if routing was created by this revised item and
2347: -- nothing else references this
2348:
2349: DELETE FROM BOM_OPERATIONAL_ROUTINGS bor
2350: WHERE EXISTS ( SELECT NULL
2351: FROM ENG_REVISED_ITEMS ri
2352: WHERE bor.routing_sequence_id = ri.change_notice
2353: AND bor.routing_sequence_id = ri.routing_sequence_id

Line 2367: FROM BOM_OPERATIONAL_ROUTINGS bor2

2363: OR bos.change_notice <> p_eco_name)
2364: )
2365: AND (( bor.alternate_routing_designator IS NULL
2366: AND NOT EXISTS( SELECT NULL
2367: FROM BOM_OPERATIONAL_ROUTINGS bor2
2368: WHERE bor2.organization_id = bor.organization_id
2369: AND bor2.assembly_item_id = bor.assembly_item_id
2370: AND bor2.alternate_routing_designator IS NOT NULL )
2371: )

Line 2396: FROM BOM_OPERATIONAL_ROUTINGS bor

2392: WHERE ri.organization_id = p_org_id
2393: AND ri.change_notice = p_eco_name
2394: AND ri.status_type = 5 -- Cancelled
2395: AND NOT EXISTS (SELECT 'No Rtg Header'
2396: FROM BOM_OPERATIONAL_ROUTINGS bor
2397: WHERE bor.routing_sequence_id = ri.routing_sequence_id
2398: ) ;
2399: END IF;
2400: