DBA Data[Home] [Help]

APPS.BOM_VAL_TO_ID dependencies on BOM_OPERATIONAL_ROUTINGS

Line 128: FROM bom_operational_routings bor

124: INTO l_id
125: FROM bom_operation_sequences bos
126: WHERE routing_sequence_id =
127: (SELECT common_routing_sequence_id
128: FROM bom_operational_routings bor
129: WHERE assembly_item_id = p_assembly_item_id
130: and organization_id = p_organization_id
131: and nvl(alternate_routing_designator, nvl(p_alternate_bom_designator, 'NONE')) =
132: nvl(p_alternate_bom_designator, 'NONE')

Line 137: FROM bom_operational_routings bor2

133: and ( p_alternate_bom_designator is null
134: or (p_alternate_bom_designator is not null
135: and (alternate_routing_designator = p_alternate_bom_designator
136: or not exists (SELECT null
137: FROM bom_operational_routings bor2
138: WHERE bor2.assembly_item_id = p_assembly_item_id
139: and bor2.organization_id = p_organization_id
140: and bor2.alternate_routing_designator =
141: p_alternate_bom_designator