APPS.INV_CALCULATE_EXP_DATE dependencies on MTL_LOT_NUMBERS

Line 347: FROM mtl_lot_numbers

343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344: BEGIN /*begin segment 2 */
345: SELECT origination_date
346: INTO x_orig_date
347: FROM mtl_lot_numbers
348: WHERE inventory_item_id = p_inventory_item_id
349: AND lot_number = p_lot_number
350: AND organization_id = p_organization_id;
351: EXCEPTION

Line 394: FROM mtl_lot_numbers

390: x_lot_exist := 'FALSE';
391: BEGIN /*begin segment 2 */
392: SELECT 1
393: INTO l_lot_exists
394: FROM mtl_lot_numbers
395: WHERE inventory_item_id = p_inventory_item_id
396: AND lot_number = p_lot_number
397: AND organization_id = p_organization_id;
398: EXCEPTION

Line 594: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

590: , p_vendor_id IN VARCHAR2 := NULL
591: , p_parent_lot_number IN VARCHAR2 := NULL
592: -- bug#6073680 END. Added following parameters to handle WMS Attributes
593: ) IS
594: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
595: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
596: l_api_version NUMBER;
597: l_init_msg_list VARCHAR2(100);
598: l_commit VARCHAR2(100);

Line 595: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

591: , p_parent_lot_number IN VARCHAR2 := NULL
592: -- bug#6073680 END. Added following parameters to handle WMS Attributes
593: ) IS
594: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
595: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
596: l_api_version NUMBER;
597: l_init_msg_list VARCHAR2(100);
598: l_commit VARCHAR2(100);
599: l_return_status VARCHAR2(1) ;