DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on WIP_REPETITIVE_ITEMS

Line 3270: from wip_repetitive_items

3266:
3267: BEGIN
3268: select line_id
3269: into v_wip_line_id
3270: from wip_repetitive_items
3271: where load_distribution_priority =
3272: (select min(load_distribution_priority)
3273: from wip_repetitive_items
3274: where organization_id = p_kanban_card_rec_tbl(1).organization_id

Line 3273: from wip_repetitive_items

3269: into v_wip_line_id
3270: from wip_repetitive_items
3271: where load_distribution_priority =
3272: (select min(load_distribution_priority)
3273: from wip_repetitive_items
3274: where organization_id = p_kanban_card_rec_tbl(1).organization_id
3275: and primary_item_id = p_kanban_card_rec_tbl(1).inventory_item_id
3276: group by organization_id,primary_item_id)
3277: and organization_id = p_kanban_card_rec_tbl(1).organization_id