APPS.GMD_SAMPLES_PUB dependencies on MTL_LOT_NUMBERS

Line 1446: -- Bug 4165704: mtl_lot_numbers replaced ic_lots_mst and lot_id no longer used

1442: -- WHERE item_id = p_sample_rec.item_id
1443: -- AND inactive_ind = 0
1444: -- AND delete_mark = 0;
1445:
1446: -- Bug 4165704: mtl_lot_numbers replaced ic_lots_mst and lot_id no longer used
1447: --CURSOR c_item_lot IS
1448: --SELECT lot_no, sublot_no
1449: --FROM ic_lots_mst
1450: --WHERE item_id = p_sample_rec.item_id

Line 1455: FROM mtl_lot_numbers

1451: --AND lot_id = p_sample_rec.lot_id
1452: --AND delete_mark = 0;
1453: /*CURSOR c_item_lot IS
1454: SELECT 1
1455: FROM mtl_lot_numbers
1456: WHERE inventory_item_id = p_sample_rec.inventory_item_id
1457: --AND lot_number = p_sample_rec.lot_number
1458: AND organization_id = p_sample_rec.organization_id
1459: AND ((p_sample_rec.parent_lot_number IS NULL )

Line 1465: FROM mtl_lot_numbers

1461:
1462: -- srakrish bug 5687499: Implementing Child lot controlled onstraints. Replaced the above cursor with the one below.
1463: CURSOR c_item_lot(p_child_lot_flag varchar2) IS
1464: SELECT 1
1465: FROM mtl_lot_numbers
1466: WHERE inventory_item_id = p_sample_rec.inventory_item_id
1467: --AND lot_number = p_sample_rec.lot_number
1468: AND((p_child_lot_flag = 'Y' and p_sample_rec.lot_number IS NOT NULL and lot_number = p_sample_rec.lot_number)
1469: OR (p_child_lot_flag = 'Y' and p_sample_rec.lot_number IS NULL)

Line 1492: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;

1488:
1489: l_dummy NUMBER;
1490: l_lot_ctl NUMBER;
1491: l_child_lot_flag VARCHAR2(2);
1492: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;
1493: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
1494: l_sample_rec GMD_SAMPLES%ROWTYPE;
1495: l_return_status VARCHAR2(1);
1496:

Line 1493: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;

1489: l_dummy NUMBER;
1490: l_lot_ctl NUMBER;
1491: l_child_lot_flag VARCHAR2(2);
1492: l_lot_number MTL_LOT_NUMBERS.lot_number%TYPE;
1493: l_parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE;
1494: l_sample_rec GMD_SAMPLES%ROWTYPE;
1495: l_return_status VARCHAR2(1);
1496:
1497: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;