APPS.INV_GMI_MIGRATION dependencies on IC_LOTS_MST

Line 66: | Update status_id column in ic_lots_mst for |

62: | Kedar Bavadekar - 03/29/2010 Bug#9403348 |
63: | Modified migrate_inventory_balances to fix sql |
64: | that fetches inventory locator |
65: | Kedar Bavadekar - 11/30/2010 Bug#10413599 |
66: | Update status_id column in ic_lots_mst for |
67: | existing status and also changed update on |
68: | mtl_material_statues to mtl_material_statues_b |
69: | in procedure migrate_lot_status |
70: | Srinivasulu Puri- 11/04/2011 Bug#13335019 |

Line 213: FROM ic_lots_mst

209: BEGIN
210: SELECT lot_no ||decode(sublot_no, NULL,NULL,', '||sublot_no)
211: ||'('||to_char(p_lot_id)||')'
212: INTO l_return_val
213: FROM ic_lots_mst
214: WHERE lot_id = p_lot_id AND
215: rownum = 1;
216: EXCEPTION
217: WHEN NO_DATA_FOUND THEN

Line 819: -- Update status_id column in ic_lots_mst for

815: -- unchecked
816: -- Kedar Bavadekar - 03/17/10 . Fix for Bug#9143261
817: -- - Update on-hand control field for exisiting status
818: -- Kedar Bavadekar - 11/30/2010 Bug#10413599
819: -- Update status_id column in ic_lots_mst for
820: -- existing status and also changed update on
821: -- mtl_material_statues to mtl_material_statues_b
822: -- in procedure migrate_lot_status
823: --====================================================================*/

Line 1667: FROM ic_item_cnv c, ic_lots_mst_mig m

1663: l_migrated_ind PLS_INTEGER;
1664:
1665: CURSOR c_ic_item_cnv IS
1666: SELECT m.parent_lot_number, m.lot_number, m.organization_id, c.*
1667: FROM ic_item_cnv c, ic_lots_mst_mig m
1668: WHERE
1669: c.rowid BETWEEN p_start_rowid AND p_end_rowid and
1670: c.item_id = m.item_id and
1671: c.lot_id = m.lot_id and

Line 2042: UPDATE ic_lots_mst_mig

2038: adetail.last_update_date
2039: );
2040: END LOOP;
2041: END LOOP;
2042: UPDATE ic_lots_mst_mig
2043: SET
2044: conv_migrated_ind = 1,
2045: last_update_date = sysdate,
2046: last_updated_by = 0