APPS.FLM_AUTO_REPLENISHMENT dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 172: FROM mtl_kanban_pull_sequences mkps,

168:
169: BEGIN
170: SELECT mkps.pull_sequence_id
171: INTO l_pull_sequence_id
172: FROM mtl_kanban_pull_sequences mkps,
173: bom_inventory_components bic,
174: mtl_system_items msi
175: WHERE mkps.inventory_item_id = p_item_id
176: AND mkps.organization_id = p_organization_id

Line 990: FROM MTL_KANBAN_PULL_SEQUENCES WHERE PULL_SEQUENCE_ID = l_comp_table(l_comp_count).pull_sequence_id;

986:
987: SELECT INVENTORY_ITEM_ID,ORGANIZATION_ID,SUBINVENTORY_NAME,SOURCE_TYPE,LOCATOR_ID,SOURCE_ORGANIZATION_ID,
988: SOURCE_SUBINVENTORY,SOURCE_LOCATOR_ID,WIP_LINE_ID,1
989: INTO l_item_id,l_org_id,l_subinv,l_src_type,l_locator,l_src_org_id,l_src_subinv,l_src_locator,l_wip_line_id,l_release_kanban_flag
990: FROM MTL_KANBAN_PULL_SEQUENCES WHERE PULL_SEQUENCE_ID = l_comp_table(l_comp_count).pull_sequence_id;
991:
992: r_kanban_card_rec := null;
993: r_kanban_card_rec.pull_sequence_id := l_comp_table(l_comp_count).pull_sequence_id;
994: r_kanban_card_rec.kanban_card_id := null;