APPS.FLM_KANBAN_CONSOLIDATION dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 373: FROM Mtl_Kanban_Pull_Sequences MKP

369: END IF;
370:
371: BEGIN
372: SELECT MKP.auto_allocate_flag INTO l_auto_Allocate_flag
373: FROM Mtl_Kanban_Pull_Sequences MKP
374: WHERE MKP.pull_sequence_id=l_Kanban_Card_Rec_Tbl(1).pull_sequence_id;
375: EXCEPTION
376: WHEN OTHERS THEN
377: l_auto_Allocate_flag := 0;

Line 727: mtl_kanban_pull_sequences mkps

723: null,null,null,null,null,null,null,null,mkc.replenishment_count,mkc.max_replenishments,mkc.disable_date,mkc.replacement_flag
724: bulk collect into v_cards_to_consolidate
725: from
726: mtl_kanban_cards mkc,
727: mtl_kanban_pull_sequences mkps
728: where mkps.organization_id = p_organization_id
729: and nvl(mkps.consolidation_group,'####') = nvl(p_group_code,'####')
730: and mkps.pull_sequence_id = mkc.pull_sequence_id
731: and trunc(mkc.supply_status) = INV_Kanban_PVT.G_Supply_Status_Consolidate

Line 744: from mtl_kanban_pull_sequences

740: LOOP
741: if l_card_counter is not null then
742: if v_cards_to_consolidate(l_card_counter).pull_sequence_id <> nvl(l_prev_pull_seq,-100) then
743: select replenishment_lead_time into l_lead_time
744: from mtl_kanban_pull_sequences
745: where pull_sequence_id = v_cards_to_consolidate(l_card_counter).pull_sequence_id;
746: end if;
747: if l_prev_pull_seq is null then
748: l_prev_pull_seq := v_cards_to_consolidate(l_card_counter).pull_sequence_id;