APPS.FLM_KANBAN_CONSOLIDATION dependencies on MTL_KANBAN_CARDS

Line 171: Update Mtl_Kanban_Cards

167: l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count := nvl(l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count,0)+1;
168: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Update_Date := SYSDATE;
169: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Updated_By := FND_GLOBAL.USER_ID;
170: fnd_file.put_line(fnd_file.log,'after card upd');
171: Update Mtl_Kanban_Cards
172: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_Empty,
173: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,
174: replenishment_count = nvl(replenishment_count,0)+1,
175: Last_Update_Date = SYSDATE,

Line 391: Update Mtl_Kanban_Cards

387: l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count := nvl(l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count,0)+1;
388: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Update_Date := SYSDATE;
389: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Updated_By := FND_GLOBAL.USER_ID;
390:
391: Update Mtl_Kanban_Cards
392: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_InProcess,
393: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,
394: replenishment_count = nvl(replenishment_count,0)+1,
395: Last_Update_Date = SYSDATE,

Line 726: mtl_kanban_cards mkc,

722: mkc.attribute12,mkc.attribute13,mkc.attribute14,mkc.attribute15,mkc.request_id,mkc.program_application_id,mkc.program_id,mkc.program_update_date,null,
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