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 4201: from bom_routing_alternates_v bor

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