APPS.BOM_COMPONENT_API dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1755: FROM bom_operation_sequences a, bom_operational_routings b

1751: stmt_num := 2;
1752: IF (op_seq <> 1) THEN
1753: SELECT distinct operation_seq_num
1754: INTO dummy
1755: FROM bom_operation_sequences a, bom_operational_routings b
1756: WHERE b.organization_id = org_id
1757: AND b.assembly_item_id = assy_id
1758: AND operation_seq_num = op_seq
1759: -- AND a.effectivity_date < sysdate

Line 1771: FROM bom_operational_routings c

1767: or
1768: (b.alternate_routing_designator is null
1769: AND not exists
1770: (SELECT 'No alt routing'
1771: FROM bom_operational_routings c
1772: WHERE c.organization_id = org_id
1773: AND c.assembly_item_id = assy_id
1774: AND c.alternate_routing_designator = alt_desg)))));
1775: END IF;

Line 2655: from BOM_OPERATIONAL_ROUTINGS bor

2651: FROM bom_operation_sequences bos
2652: WHERE c3rec.OSN = bos.operation_seq_num
2653: AND bos.ROUTING_SEQUENCE_ID =
2654: (select COMMON_ROUTING_SEQUENCE_ID
2655: from BOM_OPERATIONAL_ROUTINGS bor
2656: where bor.ASSEMBLY_ITEM_ID = c3rec.AII
2657: and bor.ORGANIZATION_ID = c3rec.OI
2658: and NVL(bor.ALTERNATE_ROUTING_DESIGNATOR, NVL(c3rec.ABD, 'NONE')) = NVL(c3rec.ABD, 'NONE')
2659: AND (c3rec.ABD IS NULL

Line 2664: FROM BOM_OPERATIONAL_ROUTINGS bor2

2660: OR (c3rec.ABD IS NOT NULL
2661: AND ( bor.ALTERNATE_ROUTING_DESIGNATOR = c3rec.ABD
2662: OR NOT EXISTS
2663: (SELECT NULL
2664: FROM BOM_OPERATIONAL_ROUTINGS bor2
2665: WHERE bor2.ASSEMBLY_ITEM_ID = c3rec.AII
2666: AND bor2.ORGANIZATION_ID = c3rec.OI
2667: AND bor2.ALTERNATE_ROUTING_DESIGNATOR = c3rec.ABD)))))
2668: AND bos.EFFECTIVITY_DATE < sysdate

Line 3803: from BOM_OPERATIONAL_ROUTINGS bor

3799: FROM bom_operation_sequences bos
3800: WHERE c1rec.OSN = bos.operation_seq_num
3801: AND bos.ROUTING_SEQUENCE_ID =
3802: (select COMMON_ROUTING_SEQUENCE_ID
3803: from BOM_OPERATIONAL_ROUTINGS bor
3804: where bor.ASSEMBLY_ITEM_ID = c1rec.AII
3805: and bor.ORGANIZATION_ID = c1rec.OI
3806: and NVL(bor.ALTERNATE_ROUTING_DESIGNATOR, NVL(c1rec.ABD, 'NONE')) = NVL(c1rec.ABD,'NONE')
3807: AND (c1rec.ABD IS NULL

Line 3812: FROM BOM_OPERATIONAL_ROUTINGS bor2

3808: OR (c1rec.ABD IS NOT NULL
3809: AND ( bor.ALTERNATE_ROUTING_DESIGNATOR = c1rec.ABD
3810: OR NOT EXISTS
3811: (SELECT NULL
3812: FROM BOM_OPERATIONAL_ROUTINGS bor2
3813: WHERE bor2.ASSEMBLY_ITEM_ID = c1rec.AII
3814: AND bor2.ORGANIZATION_ID = c1rec.OI
3815: AND bor2.ALTERNATE_ROUTING_DESIGNATOR = c1rec.
3816: ABD)))))