APPS.INV_CALCULATE_EXP_DATE dependencies on MTL_LOT_NUMBERS

Line 348: FROM mtl_lot_numbers

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

Line 392: FROM mtl_lot_numbers

388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389: BEGIN /*begin segment 2 */
390: SELECT origination_date
391: INTO x_orig_date
392: FROM mtl_lot_numbers
393: WHERE inventory_item_id = p_inventory_item_id
394: AND lot_number = p_lot_number
395: AND organization_id = p_organization_id;
396: EXCEPTION

Line 439: FROM mtl_lot_numbers

435: x_lot_exist := 'FALSE';
436: BEGIN /*begin segment 2 */
437: SELECT 1
438: INTO l_lot_exists
439: FROM mtl_lot_numbers
440: WHERE inventory_item_id = p_inventory_item_id
441: AND lot_number = p_lot_number
442: AND organization_id = p_organization_id;
443: EXCEPTION

Line 639: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

635: , p_vendor_id IN VARCHAR2 := NULL
636: , p_parent_lot_number IN VARCHAR2 := NULL
637: -- bug#6073680 END. Added following parameters to handle WMS Attributes
638: ) IS
639: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
640: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
641: l_api_version NUMBER;
642: l_init_msg_list VARCHAR2(100);
643: l_commit VARCHAR2(100);

Line 640: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;

636: , p_parent_lot_number IN VARCHAR2 := NULL
637: -- bug#6073680 END. Added following parameters to handle WMS Attributes
638: ) IS
639: l_in_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
640: x_lot_rec MTL_LOT_NUMBERS%ROWTYPE;
641: l_api_version NUMBER;
642: l_init_msg_list VARCHAR2(100);
643: l_commit VARCHAR2(100);
644: l_return_status VARCHAR2(1) ;