APPS.INV_LOT_API_PKG dependencies on MTL_SYSTEM_ITEMS

Line 37: FROM mtl_system_items

33: /* Cursor definition to check whether item is a valid and it's lot, child lot controlled */
34: CURSOR c_chk_msi_attr IS
35: SELECT lot_control_code,
36: child_lot_flag
37: FROM mtl_system_items
38: WHERE inventory_item_id = p_inventory_item_id
39: AND organization_id = p_organization_id;
40:
41: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;

Line 49: /* Check item attributes in Mtl_system_items Table */

45: x_return_status := fnd_api.g_ret_sts_success;
46:
47: /******************* START Item validation ********************/
48:
49: /* Check item attributes in Mtl_system_items Table */
50: OPEN c_chk_msi_attr ;
51: FETCH c_chk_msi_attr INTO l_chk_msi_attr_rec;
52:
53: IF c_chk_msi_attr%NOTFOUND THEN

Line 262: -- from Mtl_System_Items or from Mtl_Parameters and set l_copy_lot_attribute_flag.

258: /* Verify p_copy_lot_attribute_flag and populate l_copy_lot_attribute_flag */
259:
260: IF p_copy_lot_attribute_flag IS NULL THEN
261: -- Based on the value of Mtl_parameters.lot_number_generation retrieve the copy_lot_attribute_flag either
262: -- from Mtl_System_Items or from Mtl_Parameters and set l_copy_lot_attribute_flag.
263:
264: /* Check needed for Lot UOM conversion */
265: OPEN c_lot_uom_conv (p_lot_rec.organization_id) ;
266: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;

Line 278: FROM mtl_system_items

274: IF l_lot_uom_conv.lot_number_generation = 1 THEN
275: l_copy_lot_attribute_flag := NVL(l_lot_uom_conv.copy_lot_attribute_flag,'N') ;
276: ELSIF l_lot_uom_conv.lot_number_generation IN (2,3) THEN
277: SELECT copy_lot_attribute_flag INTO l_copy_lot_attribute_flag
278: FROM mtl_system_items
279: WHERE inventory_item_id = p_lot_rec.inventory_item_id
280: AND organization_id = p_lot_rec.organization_id;
281: END IF;
282:

Line 569: FROM mtl_system_items_b

565: , expiration_action_interval
566: , retest_interval
567: , maturity_days
568: , hold_days
569: FROM mtl_system_items_b
570: WHERE organization_id = cp_organization_id
571: AND inventory_item_id = cp_inventory_item_id;
572:
573: -- nsinghi bug#5209065 rework START. If existing lot,

Line 915: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

911: user_defined_exp_date CONSTANT NUMBER := 4;
912: l_mtl_gen_obj_no NUMBER ;
913:
914: /*Program variables declaration */
915: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
916: l_chk_lot_uniqueness BOOLEAN;
917: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
918: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
919: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;

Line 917: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;

913:
914: /*Program variables declaration */
915: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
916: l_chk_lot_uniqueness BOOLEAN;
917: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
918: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
919: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
920: l_wms_installed VARCHAR2(5);
921: l_lot_number_uniqueness NUMBER;

Line 918: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;

914: /*Program variables declaration */
915: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
916: l_chk_lot_uniqueness BOOLEAN;
917: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
918: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
919: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
920: l_wms_installed VARCHAR2(5);
921: l_lot_number_uniqueness NUMBER;
922: l_return_status VARCHAR2(1);

Line 1195: FROM mtl_system_items

1191: SELECT shelf_life_days
1192: , shelf_life_code
1193: INTO l_shelf_life_days
1194: , l_shelf_life_code
1195: FROM mtl_system_items
1196: WHERE inventory_item_id = p_inventory_item_id
1197: AND organization_id = p_organization_id;
1198: EXCEPTION
1199: WHEN NO_DATA_FOUND THEN

Line 1297: FROM mtl_system_items

1293:
1294: BEGIN
1295: SELECT lot_status_enabled , default_lot_status_id
1296: INTO l_lot_status_flag , l_def_lot_status
1297: FROM mtl_system_items
1298: WHERE organization_id = p_organization_id
1299: AND inventory_item_id = p_inventory_item_id ;
1300:
1301: IF p_status_id IS NOT NULL THEN

Line 1641: FROM mtl_system_items

1637: l_lot_record c_get_lot_record%ROWTYPE;
1638:
1639: CURSOR c_get_item_info IS
1640: SELECT *
1641: FROM mtl_system_items
1642: WHERE organization_id = p_organization_id
1643: AND inventory_item_id = p_inventory_item_id ;
1644:
1645: l_item_info c_get_item_info%ROWTYPE;