DBA Data[Home] [Help]

APPS.BOM_VAL_TO_ID dependencies on BOM_OPERATIONAL_ROUTINGS

Line 103: FROM bom_operational_routings bor

99: INTO l_id
100: FROM bom_operation_sequences bos
101: WHERE routing_sequence_id =
102: (SELECT common_routing_sequence_id
103: FROM bom_operational_routings bor
104: WHERE assembly_item_id = p_assembly_item_id
105: and organization_id = p_organization_id
106: and nvl(alternate_routing_designator, nvl(p_alternate_bom_designator, 'NONE')) =
107: nvl(p_alternate_bom_designator, 'NONE')

Line 112: FROM bom_operational_routings bor2

108: and ( p_alternate_bom_designator is null
109: or (p_alternate_bom_designator is not null
110: and (alternate_routing_designator = p_alternate_bom_designator
111: or not exists (SELECT null
112: FROM bom_operational_routings bor2
113: WHERE bor2.assembly_item_id = p_assembly_item_id
114: and bor2.organization_id = p_organization_id
115: and bor2.alternate_routing_designator =
116: p_alternate_bom_designator