APPS.INV_RCV_COMMON_APIS dependencies on MTL_LOT_NUMBERS

Line 4486: UPDATE mtl_lot_numbers

4482: BEGIN
4483: IF (l_debug = 1) THEN
4484: print_debug('Updating the lot number attributes',4);
4485: END IF;
4486: UPDATE mtl_lot_numbers
4487: SET (VENDOR_ID,
4488: GRADE_CODE,
4489: ORIGINATION_DATE,
4490: DATE_CODE,

Line 4654: FROM mtl_lot_numbers

4650: attribute12,
4651: attribute13,
4652: attribute14,
4653: attribute15
4654: FROM mtl_lot_numbers
4655: WHERE organization_id = p_from_organization_id
4656: AND inventory_item_id = p_inventory_item_id
4657: AND lot_number = p_lot_number)
4658: WHERE organization_id = p_organization_id

Line 4730: FROM MTL_LOT_NUMBERS

4726: IF p_transfer_organization_id IS NOT NULL THEN
4727: BEGIN
4728: SELECT STATUS_ID
4729: INTO l_status_id
4730: FROM MTL_LOT_NUMBERS
4731: WHERE LOT_NUMBER = p_lot_number
4732: AND ORGANIZATION_ID = p_transfer_organization_id
4733: AND INVENTORY_ITEM_ID = p_inventory_item_id;
4734:

Line 4753: FROM mtl_lot_numbers

4749: organization_id=p_organization_id;
4750:
4751: SELECT 'TRUE'
4752: INTO l_exists
4753: FROM mtl_lot_numbers
4754: WHERE lot_number = p_lot_number
4755: AND organization_id = p_organization_id
4756: AND inventory_item_id = p_inventory_item_id;
4757: EXCEPTION