APPS.FLM_KANBAN_PLANNING_UTIL dependencies on FLM_EKB_ACT_SNAPSHOT

Line 1232: FROM FLM_EKB_ACT_SNAPSHOT

1228: l_range := nvl(trunc(l_end_date - l_start_date),0);
1229:
1230: SELECT ( SUM(KANBAN_SIZE) / decode(l_range,0,1,l_range) )
1231: into l_actual_demand
1232: FROM FLM_EKB_ACT_SNAPSHOT
1233: WHERE PULL_SEQUENCE_ID = p_pull_sequence_id
1234: and REPLENISHMENT_DATE between l_start_date and l_end_date;
1235:
1236: return l_actual_demand;

Line 1252: FROM FLM_EKB_ACT_SNAPSHOT

1248: l_start_date := l_end_date - nvl(flm_kanban_config_params.get_lt_range_days(p_org_id),30);
1249:
1250: SELECT ( SUM(LEAD_TIME) / decode(count(1),0,1,count(1)) )
1251: into l_act_lead_time
1252: FROM FLM_EKB_ACT_SNAPSHOT
1253: WHERE PULL_SEQUENCE_ID = p_pull_sequence_id
1254: and LEAD_TIME > 0
1255: and RECEIVED_DATE between l_start_date and l_end_date;
1256: