APPS.FLM_EKB_ACTUAL_DEMAND dependencies on FLM_EKB_ACT_SNAPSHOT

Line 142: Insert into FLM_EKB_ACT_SNAPSHOT(

138: -- for c_ps_activity in c_ps_for_org loop - Start of loop for picking up ps for org.
139:
140: for c_card_activity in c_cards_for_ps(l_last_run_date) loop -- Start of for loop for every card_id
141:
142: Insert into FLM_EKB_ACT_SNAPSHOT(
143: ORGANIZATION_ID
144: ,PULL_SEQUENCE_ID
145: ,KANBAN_CARD_ID
146: ,REPLENISHMENT_ACTIVITY_ID

Line 185: Update FLM_EKB_ACT_SNAPSHOT FEAS

181: group by c_card_activity.organization_id, c_card_activity.pull_sequence_id,c_card_activity.kanban_card_id , REPLENISHMENT_CYCLE_ID
182: Order by REPLENISHMENT_CYCLE_ID;
183:
184:
185: Update FLM_EKB_ACT_SNAPSHOT FEAS
186: Set ( REPLENISHMENT_DATE , KANBAN_SIZE ) = (Select CREATION_DATE,KANBAN_SIZE
187: from MTL_KANBAN_CARD_ACTIVITY MKCA
188: where MKCA.Kanban_Activity_id = FEAS.REPLENISHMENT_ACTIVITY_ID)
189: where REPLENISHMENT_DATE is null;

Line 248: from flm_ekb_act_snapshot

244:
245: /* This part is for testing
246: select count(*)
247: into l_row_count
248: from flm_ekb_act_snapshot
249: where organization_id = p_organization_id;
250:
251: -- FND_FILE.put_line(FND_FILE.LOG, 'Total rows for this organization are : '||l_row_count);
252: -- dbms_output.put_line('Total rows for this organization are : '||l_row_count);