APPS.INV_RCV_COMMON_APIS dependencies on MTL_LOT_NUMBERS

Line 5009: UPDATE mtl_lot_numbers

5005: BEGIN
5006: IF (l_debug = 1) THEN
5007: print_debug('Updating the lot number attributes',4);
5008: END IF;
5009: UPDATE mtl_lot_numbers
5010: SET (VENDOR_ID,
5011: GRADE_CODE,
5012: ORIGINATION_DATE,
5013: DATE_CODE,

Line 5177: FROM mtl_lot_numbers

5173: attribute12,
5174: attribute13,
5175: attribute14,
5176: attribute15
5177: FROM mtl_lot_numbers
5178: WHERE organization_id = p_from_organization_id
5179: AND inventory_item_id = p_inventory_item_id
5180: AND lot_number = p_lot_number)
5181: WHERE organization_id = p_organization_id

Line 5255: FROM MTL_LOT_NUMBERS

5251: IF p_transfer_organization_id IS NOT NULL THEN
5252: BEGIN
5253: SELECT STATUS_ID
5254: INTO l_status_id
5255: FROM MTL_LOT_NUMBERS
5256: WHERE LOT_NUMBER = p_lot_number
5257: AND ORGANIZATION_ID = p_transfer_organization_id
5258: AND INVENTORY_ITEM_ID = p_inventory_item_id;
5259:

Line 5278: FROM mtl_lot_numbers

5274: organization_id=p_organization_id;
5275:
5276: SELECT 'TRUE'
5277: INTO l_exists
5278: FROM mtl_lot_numbers
5279: WHERE lot_number = p_lot_number
5280: AND organization_id = p_organization_id
5281: AND inventory_item_id = p_inventory_item_id;
5282: EXCEPTION