APPS.FLM_EKB_UNMOVED_CARDS dependencies on MTL_KANBAN_CARDS

Line 157: FROM MTL_KANBAN_PULL_SEQUENCES MKPS , MTL_KANBAN_CARDS MKC,

153: MKPS.PULL_SEQUENCE_ID,
154: MKC.KANBAN_CARD_ID,
155: MKPS.ORGANIZATION_ID,
156: MKPS.REPLENISHMENT_LEAD_TIME
157: FROM MTL_KANBAN_PULL_SEQUENCES MKPS , MTL_KANBAN_CARDS MKC,
158: MTL_KANBAN_CARD_ACTIVITY MKCA
159: where MKPS.ORGANIZATION_ID = p_organization_id
160: and MKPS.PULL_SEQUENCE_ID = MKC.PULL_SEQUENCE_ID
161: and MKPS.REPLENISHMENT_LEAD_TIME > 0

Line 172: Update MTL_KANBAN_CARDS

168: ORDER BY MKPS.PULL_SEQUENCE_ID;
169:
170: Begin
171:
172: Update MTL_KANBAN_CARDS
173: Set MOVE_STATUS = null
174: where pull_sequence_id in ( select pull_sequence_id from
175: MTL_KANBAN_PULL_SEQUENCES where ORGANIZATION_ID = p_organization_id );
176:

Line 289: Update MTL_KANBAN_CARDS

285:
286: -- dbms_output.put_line('Kanban card id : '||c_card_activity.kanban_card_id);
287: -- dbms_output.put_line('Kanban activity id : '||c_card_activity.kanban_activity_id);
288:
289: Update MTL_KANBAN_CARDS
290: SET MOVE_STATUS = 1,
291: LAST_STATUS_CHANGE_DATE = c_ps_activity.CREATION_DATE,
292: LAST_UPDATE_DATE = sysdate,
293: LAST_UPDATED_BY = G_USER_ID

Line 311: Update MTL_KANBAN_CARDS

307: /* User is passing the information via custom hook call as which cards in this Pull_sequence are to
308: * be marked as Unmoved. No further validation is required */
309:
310: for i in x_uc_from_custom.FIRST..x_uc_from_custom.LAST LOOP
311: Update MTL_KANBAN_CARDS
312: SET MOVE_STATUS = x_uc_from_custom(i).unmoved_flag,
313: LAST_STATUS_CHANGE_DATE = x_uc_from_custom(i).last_activity_date,
314: LAST_UPDATE_DATE = sysdate,
315: LAST_UPDATED_BY = G_USER_ID

Line 341: Update MTL_KANBAN_CARDS

337: -- dbms_output.put_line('Kanban card id : '||c_ps_activity.kanban_card_id);
338: -- dbms_output.put_line('Kanban activity id : '||c_ps_activity.kanban_activity_id);
339: -- dbms_output.put_line('supply status is : '||c_ps_activity.supply_status);
340:
341: Update MTL_KANBAN_CARDS
342: SET MOVE_STATUS = 1,
343: LAST_STATUS_CHANGE_DATE = c_ps_activity.CREATION_DATE,
344: LAST_UPDATE_DATE = sysdate,
345: LAST_UPDATED_BY = G_USER_ID

Line 422: from mtl_kanban_cards

418:
419: /* This part is for testing
420: select count(move_status)
421: into l_row_count
422: from mtl_kanban_cards
423: where Move_status = 1;
424:
425: FND_FILE.put_line(FND_FILE.LOG, 'Total rows with Unmoved cards are : '||l_row_count);
426: dbms_output.put_line('Total rows with Unmoved cards are : '||l_row_count);