APPS.ENG_ECO_UTIL dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1203: (select 'x' from bom_operational_routings

1199: UPDATE BOM_OPERATION_SEQUENCES bos
1200: SET bos.EFFECTIVITY_DATE = p_effectivity_date
1201: WHERE bos.CHANGE_NOTICE = x_change_notice
1202: AND exists
1203: (select 'x' from bom_operational_routings
1204: where routing_sequence_id = bos.routing_sequence_id
1205: and organization_id = x_organization_id )
1206: AND bos.IMPLEMENTATION_DATE IS NULL;
1207:

Line 1219: (select 'x' from bom_operational_routings

1215: SET bos1.DISABLE_DATE = p_effectivity_date
1216: WHERE bos1.CHANGE_NOTICE = x_change_notice
1217: and bos1.ACD_TYPE = 3 -- ACD Type: Disable
1218: AND exists
1219: (select 'x' from bom_operational_routings
1220: where routing_sequence_id = bos1.routing_sequence_id
1221: and organization_id = x_organization_id )
1222: AND bos1.IMPLEMENTATION_DATE IS NULL;
1223:

Line 1553: (select 'x' from bom_operational_routings

1549: UPDATE BOM_OPERATION_SEQUENCES bos
1550: SET bos.EFFECTIVITY_DATE = p_effectivity_date
1551: WHERE bos.CHANGE_NOTICE = x_change_notice
1552: AND exists
1553: (select 'x' from bom_operational_routings
1554: where routing_sequence_id = bos.routing_sequence_id
1555: and organization_id = x_organization_id )
1556: AND bos.IMPLEMENTATION_DATE IS NULL;
1557:

Line 1569: (select 'x' from bom_operational_routings

1565: SET bos1.DISABLE_DATE = p_effectivity_date
1566: WHERE bos1.CHANGE_NOTICE = x_change_notice
1567: and bos1.ACD_TYPE = 3 -- ACD Type: Disable
1568: AND exists
1569: (select 'x' from bom_operational_routings
1570: where routing_sequence_id = bos1.routing_sequence_id
1571: and organization_id = x_organization_id )
1572: AND bos1.IMPLEMENTATION_DATE IS NULL;
1573:

Line 1922: DELETE FROM BOM_OPERATIONAL_ROUTINGS bor

1918:
1919: -- Delete the bom header if routing was created by this revised item and
1920: -- nothing else references this
1921:
1922: DELETE FROM BOM_OPERATIONAL_ROUTINGS bor
1923: WHERE EXISTS ( SELECT NULL
1924: FROM ENG_REVISED_ITEMS ri
1925: WHERE bor.routing_sequence_id = ri.change_notice
1926: AND bor.routing_sequence_id = ri.routing_sequence_id

Line 1940: FROM BOM_OPERATIONAL_ROUTINGS bor2

1936: OR bos.change_notice <> p_eco_name)
1937: )
1938: AND (( bor.alternate_routing_designator IS NULL
1939: AND NOT EXISTS( SELECT NULL
1940: FROM BOM_OPERATIONAL_ROUTINGS bor2
1941: WHERE bor2.organization_id = bor.organization_id
1942: AND bor2.assembly_item_id = bor.assembly_item_id
1943: AND bor2.alternate_routing_designator IS NOT NULL )
1944: )

Line 1969: FROM BOM_OPERATIONAL_ROUTINGS bor

1965: WHERE ri.organization_id = p_org_id
1966: AND ri.change_notice = p_eco_name
1967: AND ri.status_type = 5 -- Cancelled
1968: AND NOT EXISTS (SELECT 'No Rtg Header'
1969: FROM BOM_OPERATIONAL_ROUTINGS bor
1970: WHERE bor.routing_sequence_id = ri.routing_sequence_id
1971: ) ;
1972: END IF;
1973: