DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on BOM_ROUTING_ALTERNATES_V

Line 2373: from bom_routing_alternates_v bor

2369: bor.completion_locator_id
2370: into x_routing_seq_id,
2371: def_completion_subinventory,
2372: def_completion_locator_id
2373: from bom_routing_alternates_v bor
2374: where bor.organization_id = p_organization_id
2375: and bor.assembly_item_id = p_routing_reference_id
2376: and NVL(bor.alternate_routing_designator, '&*') = NVL(p_alt_routing_designator, '&*')
2377: and bor.routing_type = 1

Line 4198: from bom_routing_alternates_v bor

4194: l_stmt_num := 20;
4195:
4196: select bor.routing_sequence_id
4197: into l_routing_seq_id
4198: from bom_routing_alternates_v bor
4199: where bor.organization_id = p_organization_id
4200: and bor.assembly_item_id = p_kanban_assembly_id
4201: and bor.alternate_routing_designator is null
4202: and bor.routing_type = 1