APPS.INV_OPM_LOT_MIGRATION dependencies on IC_LOTS_MST_MIG

Line 26: | Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig |

22: | |
23: | HISTORY |
24: | Created - Jatinder Gogna - 3/22/05 |
25: | |
26: | Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig |
27: | B5690654 |
28: | |
29: +==========================================================================+
30: */

Line 228: -- insert it into ic_lots_mst_mig table

224: WHEN NO_DATA_FOUND THEN
225: NULL;
226: END;
227: END IF;
228: -- insert it into ic_lots_mst_mig table
229: IF (l_lot_status is NULL) THEN
230: l_lot_status := l_default_status;
231: END IF;
232: INSERT into ic_lots_mst_mig (

Line 232: INSERT into ic_lots_mst_mig (

228: -- insert it into ic_lots_mst_mig table
229: IF (l_lot_status is NULL) THEN
230: l_lot_status := l_default_status;
231: END IF;
232: INSERT into ic_lots_mst_mig (
233: item_id,
234: lot_id,
235: organization_id,
236: whse_code,

Line 287: -- Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig B5690654

283:
284:
285: /* rlnagara 2 Material Status Migration ME - As we are passing status_id as NULL while creating the l_lot_rec, below code is not needed.
286: -- Get status id
287: -- Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig B5690654
288: l_status_id := NULL;
289: IF (l_lot_status IS NOT NULL) THEN
290: l_field_name := 'Lot Status Id';
291: l_field_value := l_lot_status;

Line 473: UPDATE ic_lots_mst_mig

469: FROM ic_whse_mst
470: WHERE whse_code = p_whse_code;
471: END IF;
472:
473: UPDATE ic_lots_mst_mig
474: SET
475: organization_id = p_organization_id,
476: migrated_ind = 1,
477: last_update_date = sysdate,

Line 951: FROM ic_lots_mst_mig

947: END;
948: ELSE -- Get the parent lot only
949: SELECT count(*)
950: INTO l_count
951: FROM ic_lots_mst_mig
952: WHERE
953: item_id = p_item_id AND
954: whse_code = p_whse_code AND
955: parent_lot_number = p_lot_no AND

Line 1202: -- Check the value in ic_lots_mst_mig table

1198: ELSE
1199: l_organization_id := p_organization_id;
1200: END IF;
1201:
1202: -- Check the value in ic_lots_mst_mig table
1203: BEGIN
1204: g_item_id := p_item_id;
1205: g_lot_id := p_lot_id;
1206: g_whse_code := p_whse_code;

Line 1218: FROM ic_lots_mst_mig

1214: IF (g_location is not NULL) THEN
1215: BEGIN
1216: SELECT lot_number, parent_lot_number, status, nvl(migrated_ind, 0)
1217: INTO g_lot_number, g_parent_lot_number, l_lot_status, l_migrated_ind
1218: FROM ic_lots_mst_mig
1219: WHERE
1220: item_id = g_item_id AND
1221: lot_id = g_lot_id AND
1222: whse_code = g_whse_code AND -- only OPM whse

Line 1235: FROM ic_lots_mst_mig

1231: IF (g_location is NULL or l_migrated_ind = -1) THEN
1232:
1233: SELECT lot_number, parent_lot_number, status, migrated_ind
1234: INTO g_lot_number, g_parent_lot_number, l_lot_status, l_migrated_ind
1235: FROM ic_lots_mst_mig
1236: WHERE
1237: item_id = g_item_id AND
1238: lot_id = g_lot_id AND
1239: organization_id = g_organization_id AND -- for OPM whse or orgn