APPS.FLM_EKB_HEALTH_STATUS dependencies on MTL_KANBAN_PULL_SEQUENCES

Line 120: FROM MTL_KANBAN_PULL_SEQUENCES

116: Select
117: PULL_SEQUENCE_ID,
118: ORGANIZATION_ID,
119: ((nvl(AVG_DEPENDENT_DEMAND,0) + nvl(AVG_INDEPENDENT_DEMAND,0)) * nvl(SAFETY_STOCK_DAYS,0)) SAFETY_STOCK
120: FROM MTL_KANBAN_PULL_SEQUENCES
121: where ORGANIZATION_ID = p_organization_id
122: and SAFETY_STOCK_DAYS > 0
123: and kanban_plan_id = -1;
124:

Line 204: UPDATE MTL_KANBAN_PULL_SEQUENCES

200: inventory levels is Good. Lower than Bad level is Bad and Higher than good level is Warning. Thus
201: changed update of INV_HEALTH_STATUS accordingly*/
202:
203: if l_health >= l_good_health then
204: UPDATE MTL_KANBAN_PULL_SEQUENCES
205: SET INV_HEALTH_STATUS = 2, --Warning
206: LAST_UPDATE_DATE = sysdate,
207: LAST_UPDATED_BY = G_USER_ID
208: WHERE PULL_SEQUENCE_ID = l_pull_sequence_id;

Line 210: UPDATE MTL_KANBAN_PULL_SEQUENCES

206: LAST_UPDATE_DATE = sysdate,
207: LAST_UPDATED_BY = G_USER_ID
208: WHERE PULL_SEQUENCE_ID = l_pull_sequence_id;
209: elsif l_health < l_bad_health then
210: UPDATE MTL_KANBAN_PULL_SEQUENCES
211: SET INV_HEALTH_STATUS = 1, --Bad
212: LAST_UPDATE_DATE = sysdate,
213: LAST_UPDATED_BY = G_USER_ID
214: WHERE PULL_SEQUENCE_ID = l_pull_sequence_id;

Line 216: UPDATE MTL_KANBAN_PULL_SEQUENCES

212: LAST_UPDATE_DATE = sysdate,
213: LAST_UPDATED_BY = G_USER_ID
214: WHERE PULL_SEQUENCE_ID = l_pull_sequence_id;
215: elsif l_health < l_good_health and l_health >= l_bad_health then
216: UPDATE MTL_KANBAN_PULL_SEQUENCES
217: SET INV_HEALTH_STATUS = 3, --Good
218: LAST_UPDATE_DATE = sysdate,
219: LAST_UPDATED_BY = G_USER_ID
220: WHERE PULL_SEQUENCE_ID = l_pull_sequence_id;

Line 286: from mtl_kanban_pull_sequences

282:
283: /* This part is for testing
284: select count(*)
285: into l_row_count
286: from mtl_kanban_pull_sequences
287: where INV_HEALTH_STATUS = 1
288: and organization_id = p_organization_id;
289:
290: FND_FILE.put_line(FND_FILE.LOG, 'Total rows with Bad Health are : '||l_row_count);

Line 295: from mtl_kanban_pull_sequences

291: -- dbms_output.put_line('Total rows with Good Health are : '||l_row_count);
292:
293: select count(*)
294: into l_row_count
295: from mtl_kanban_pull_sequences
296: where INV_HEALTH_STATUS = 2
297: and organization_id = p_organization_id;
298:
299: FND_FILE.put_line(FND_FILE.LOG, 'Total rows with Warning Health are : '||l_row_count);

Line 304: from mtl_kanban_pull_sequences

300: -- dbms_output.put_line('Total rows with Warning Health are : '||l_row_count);
301:
302: select count(*)
303: into l_row_count
304: from mtl_kanban_pull_sequences
305: where INV_HEALTH_STATUS = 3
306: and organization_id = p_organization_id;
307:
308: FND_FILE.put_line(FND_FILE.LOG, 'Total rows with Good Health are : '||l_row_count);