DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on WIP_REPETITIVE_ITEMS

Line 2874: from wip_repetitive_items

2870:
2871: BEGIN
2872: select line_id
2873: into v_wip_line_id
2874: from wip_repetitive_items
2875: where load_distribution_priority =
2876: (select min(load_distribution_priority)
2877: from wip_repetitive_items
2878: where organization_id = p_kanban_card_rec_tbl(1).organization_id

Line 2877: from wip_repetitive_items

2873: into v_wip_line_id
2874: from wip_repetitive_items
2875: where load_distribution_priority =
2876: (select min(load_distribution_priority)
2877: from wip_repetitive_items
2878: where organization_id = p_kanban_card_rec_tbl(1).organization_id
2879: and primary_item_id = p_kanban_card_rec_tbl(1).inventory_item_id
2880: group by organization_id,primary_item_id)
2881: and organization_id = p_kanban_card_rec_tbl(1).organization_id