APPS.INV_LOT_API_PKG dependencies on MTL_PARAMETERS

Line 183: FROM mtl_parameters

179: /* Cursor definition to check if Lot UOM Conversion is needed */
180: CURSOR c_lot_uom_conv(cp_organization_id NUMBER) IS
181: SELECT copy_lot_attribute_flag,
182: lot_number_generation
183: FROM mtl_parameters
184: WHERE organization_id = cp_organization_id;
185:
186: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
187:

Line 298: -- Based on the value of Mtl_parameters.lot_number_generation retrieve the copy_lot_attribute_flag either

294:
295: /* Verify p_copy_lot_attribute_flag and populate l_copy_lot_attribute_flag */
296:
297: IF p_copy_lot_attribute_flag IS NULL THEN
298: -- Based on the value of Mtl_parameters.lot_number_generation retrieve the copy_lot_attribute_flag either
299: -- from Mtl_System_Items or from Mtl_Parameters and set l_copy_lot_attribute_flag.
300:
301: /* Check needed for Lot UOM conversion */
302: OPEN c_lot_uom_conv (p_lot_rec.organization_id) ;

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

295: /* Verify p_copy_lot_attribute_flag and populate l_copy_lot_attribute_flag */
296:
297: IF p_copy_lot_attribute_flag IS NULL THEN
298: -- Based on the value of Mtl_parameters.lot_number_generation retrieve the copy_lot_attribute_flag either
299: -- from Mtl_System_Items or from Mtl_Parameters and set l_copy_lot_attribute_flag.
300:
301: /* Check needed for Lot UOM conversion */
302: OPEN c_lot_uom_conv (p_lot_rec.organization_id) ;
303: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;

Line 306: -- Possible values for mtl_parameters.lot_number_generation are:

302: OPEN c_lot_uom_conv (p_lot_rec.organization_id) ;
303: FETCH c_lot_uom_conv INTO l_lot_uom_conv ;
304:
305: IF c_lot_uom_conv%FOUND THEN
306: -- Possible values for mtl_parameters.lot_number_generation are:
307: -- 1 At organization level
308: -- 3 User defined
309: -- 2 At item level
310:

Line 913: from mtl_parameters

909:
910: --bug10257769 if 'Allow Different Lot Status' set as Yes, lot status will be default from the destination
911: select nvl(allow_different_status,2)
912: into l_allow_different_status
913: from mtl_parameters
914: where organization_id = p_lot_rec.organization_id;
915: print_debug('allow different status: '||l_allow_different_status,9);
916:
917: if l_allow_different_status =1 then