APPS.FLM_EKB_LEAD_TIME dependencies on FLM_EKB_ACT_SNAPSHOT

Line 101: FROM FLM_EKB_ACT_SNAPSHOT

97: KANBAN_CARD_ID,
98: REPLENISHMENT_ACTIVITY_ID,
99: REPLENISHMENT_CYCLE_ID,
100: REPLENISHMENT_DATE
101: FROM FLM_EKB_ACT_SNAPSHOT
102: WHERE PULL_SEQUENCE_ID = l_pull_sequence_id
103: AND lead_time = 0;
104:
105:

Line 189: Update FLM_EKB_ACT_SNAPSHOT

185: end;
186:
187: if l_update_required = 'Y' then
188: -- FND_FILE.put_line(FND_FILE.LOG, 'Received Activity ID is : '||l_kanban_activity_id);
189: Update FLM_EKB_ACT_SNAPSHOT
190: Set RECEIVED_DATE = l_recv_date,
191: lead_time = to_number( l_recv_date - REPLENISHMENT_DATE ),
192: RECEIVED_ACTIVITY_ID = l_kanban_activity_id,
193: last_update_date = sysdate,

Line 212: from FLM_EKB_ACT_SNAPSHOT

208:
209: /*
210: select lead_time
211: into l_lead_time
212: from FLM_EKB_ACT_SNAPSHOT
213: where REPLENISHMENT_ACTIVITY_ID = c_card_activity.REPLENISHMENT_activity_id;
214: */
215: -- dbms_output.put_line ('final lead_time is : '||l_lead_time);
216:

Line 240: from flm_ekb_act_snapshot

236:
237: /* This part is for testing
238: select count(*)
239: into l_row_count
240: from flm_ekb_act_snapshot
241: where lead_time > 0
242: and organization_id = p_organization_id;
243:
244: FND_FILE.put_line(FND_FILE.LOG, 'Total rows updated are : '||l_row_count);