APPS.FLM_MULTIPLE_SUPPLIERS dependencies on MTL_PULL_SEQ_SUPPLIERS

Line 36: FROM mtl_pull_seq_suppliers mpss

32:
33: BEGIN
34: SELECT Sum(sourcing_percentage), Count(mpss.supplier_id)
35: INTO l_total_perc, l_sup_flag
36: FROM mtl_pull_seq_suppliers mpss
37: WHERE pull_sequence_id = p_pull_seq_id;
38: EXCEPTION
39: WHEN No_Data_Found THEN
40: l_sup_flag := 0;

Line 91: FROM mtl_pull_seq_suppliers mks,

87: mks.organization_id,
88: mks.number_of_cards actual_supplier_cards,
89: Count(mkc.kanban_card_id) existing_supplier_cards,
90: mks.number_of_cards - Nvl(Count(mkc.kanban_card_id),0) deficiency
91: FROM mtl_pull_seq_suppliers mks,
92: mtl_kanban_cards mkc
93: WHERE mks.pull_sequence_id = p_pull_seq_id
94: AND mks.pull_sequence_id = mkc.pull_sequence_id(+)
95: AND mks.supplier_id = mkc.supplier_id(+)

Line 108: FROM mtl_pull_seq_suppliers mks ,

104: mks.organization_id,
105: mks.future_no_of_cards actual_supplier_cards,
106: Count(mkc.kanban_card_id) existing_supplier_cards,
107: mks.future_no_of_cards - Nvl(Count(mkc.kanban_card_id),0) deficiency
108: FROM mtl_pull_seq_suppliers mks ,
109: mtl_kanban_cards mkc
110: WHERE mks.pull_sequence_id = p_pull_seq_id
111: AND mks.pull_sequence_id = mkc.pull_sequence_id(+)
112: AND mks.supplier_id = mkc.supplier_id(+)

Line 183: FROM mtl_pull_seq_suppliers

179: /* Return the single supplier id*/
180: IF (l_supplier = SINGLE_SUPPLIER ) THEN
181: SELECT supplier_id, supplier_site_id
182: INTO x_supplier_id, x_supplier_site_id
183: FROM mtl_pull_seq_suppliers
184: WHERE pull_sequence_id = p_pull_seq_id;
185: RETURN;
186: END IF; -- single supplier
187:

Line 262: FROM mtl_pull_seq_suppliers mks

258: PROCEDURE multiple_supplier_kanban_cards(p_pull_seq_id IN NUMBER,
259: x_retcode OUT NOCOPY VARCHAR2,
260: x_err_msg OUT NOCOPY VARCHAR2) IS
261: CURSOR supplier_cur IS SELECT mks.*
262: FROM mtl_pull_seq_suppliers mks
263: WHERE mks.pull_sequence_id = p_pull_seq_id
264: FOR UPDATE;
265:
266: supplier_rec supplier_cur%ROWTYPE;

Line 299: UPDATE mtl_pull_seq_suppliers

295: FROM mtl_kanban_pull_sequences
296: WHERE pull_sequence_id = p_pull_seq_id;
297:
298: IF (l_supplier = SINGLE_SUPPLIER ) THEN
299: UPDATE mtl_pull_seq_suppliers
300: SET number_of_cards = l_total_cards,
301: future_no_of_cards=l_tot_fut_cards
302: WHERE pull_sequence_id = p_pull_seq_id;
303: RETURN;

Line 315: UPDATE mtl_pull_seq_suppliers

311: WHILE (supplier_cur%FOUND) LOOP
312: l_supplier_cards := round(supplier_rec.sourcing_percentage/100 * l_total_cards);
313: l_future_cards:=round(supplier_rec.sourcing_percentage/100 * l_tot_fut_cards);
314:
315: UPDATE mtl_pull_seq_suppliers
316: SET number_of_cards = l_supplier_cards,
317: future_no_of_cards=l_future_cards
318: WHERE CURRENT OF supplier_cur;
319:

Line 336: UPDATE mtl_pull_seq_suppliers

332: /*Calculate cards for last supplier */
333: l_supplier_cards := l_total_cards - l_tot_sup_cards;
334: l_future_cards := l_tot_fut_cards - l_fut_sup_cards;
335:
336: UPDATE mtl_pull_seq_suppliers
337: SET number_of_cards = l_supplier_cards,
338: future_no_of_cards=l_future_cards
339: WHERE pull_sequence_id = supplier_rec_last.pull_sequence_id
340: AND supplier_id = supplier_rec_last.supplier_id