DBA Data[Home] [Help]

APPS.BOMPVALB dependencies on BOM_OPERATIONAL_ROUTINGS

Line 2191: from bom_operation_sequences a, bom_operational_routings b

2187:
2188: if (op_seq <> 1) then
2189: select operation_seq_num
2190: into dummy
2191: from bom_operation_sequences a, bom_operational_routings b
2192: where b.organization_id = org_id
2193: and b.assembly_item_id = assy_id
2194: and operation_seq_num = op_seq
2195: and b.common_routing_sequence_id = a.routing_sequence_id

Line 2204: from bom_operational_routings c

2200: ( (b.alternate_routing_designator = alt_desg)
2201: or
2202: (b.alternate_routing_designator is null
2203: and not exists (select 'No alt routing'
2204: from bom_operational_routings c
2205: where c.organization_id = org_id
2206: and c.assembly_item_id = assy_id
2207: and c.alternate_routing_designator = alt_desg)
2208: )