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: | Kedar Bavadekar 04/20/10 - Populate vendor_id, name and lot number |
30: | for Bug#9600386 in procedure |

Line 239: -- insert it into ic_lots_mst_mig table

235: WHEN NO_DATA_FOUND THEN
236: NULL;
237: END;
238: END IF;
239: -- insert it into ic_lots_mst_mig table
240: IF (l_lot_status is NULL) THEN
241: l_lot_status := l_default_status;
242: END IF;
243: INSERT into ic_lots_mst_mig (

Line 243: INSERT into ic_lots_mst_mig (

239: -- insert it into ic_lots_mst_mig table
240: IF (l_lot_status is NULL) THEN
241: l_lot_status := l_default_status;
242: END IF;
243: INSERT into ic_lots_mst_mig (
244: item_id,
245: lot_id,
246: organization_id,
247: whse_code,

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

294:
295:
296: /* 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.
297: -- Get status id
298: -- Jatinder - 11/30/06 - Use correct balance status from ic_lots_mst_mig B5690654
299: l_status_id := NULL;
300: IF (l_lot_status IS NOT NULL) THEN
301: l_field_name := 'Lot Status Id';
302: l_field_value := l_lot_status;

Line 565: UPDATE ic_lots_mst_mig

561: FROM ic_whse_mst
562: WHERE whse_code = p_whse_code;
563: END IF;
564:
565: UPDATE ic_lots_mst_mig
566: SET
567: organization_id = p_organization_id,
568: migrated_ind = 1,
569: last_update_date = sysdate,

Line 1045: FROM ic_lots_mst_mig

1041: END;
1042: ELSE -- Get the parent lot only
1043: SELECT count(*)
1044: INTO l_count
1045: FROM ic_lots_mst_mig
1046: WHERE
1047: item_id = p_item_id AND
1048: whse_code = p_whse_code AND
1049: parent_lot_number = p_lot_no AND

Line 1296: -- Check the value in ic_lots_mst_mig table

1292: ELSE
1293: l_organization_id := p_organization_id;
1294: END IF;
1295:
1296: -- Check the value in ic_lots_mst_mig table
1297: BEGIN
1298: g_item_id := p_item_id;
1299: g_lot_id := p_lot_id;
1300: g_whse_code := p_whse_code;

Line 1312: FROM ic_lots_mst_mig

1308: IF (g_location is not NULL) THEN
1309: BEGIN
1310: SELECT lot_number, parent_lot_number, status, nvl(migrated_ind, 0)
1311: INTO g_lot_number, g_parent_lot_number, l_lot_status, l_migrated_ind
1312: FROM ic_lots_mst_mig
1313: WHERE
1314: item_id = g_item_id AND
1315: lot_id = g_lot_id AND
1316: whse_code = g_whse_code AND -- only OPM whse

Line 1329: FROM ic_lots_mst_mig

1325: IF (g_location is NULL or l_migrated_ind = -1) THEN
1326:
1327: SELECT lot_number, parent_lot_number, status, migrated_ind
1328: INTO g_lot_number, g_parent_lot_number, l_lot_status, l_migrated_ind
1329: FROM ic_lots_mst_mig
1330: WHERE
1331: item_id = g_item_id AND
1332: lot_id = g_lot_id AND
1333: organization_id = g_organization_id AND -- for OPM whse or orgn