APPS.RCV_ROI_RETURN dependencies on MTL_SYSTEM_ITEMS

Line 1278: l_lot_control_code mtl_system_items.lot_control_code%TYPE;

1274: l_rqoh NUMBER;
1275: l_qr NUMBER;
1276: l_qs NUMBER;
1277: l_atr NUMBER;
1278: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1279: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;
1280: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;
1281: l_revision rcv_transactions_interface.item_revision%TYPE;
1282: l_primary_qty NUMBER;

Line 1279: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;

1275: l_qr NUMBER;
1276: l_qs NUMBER;
1277: l_atr NUMBER;
1278: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1279: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;
1280: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;
1281: l_revision rcv_transactions_interface.item_revision%TYPE;
1282: l_primary_qty NUMBER;
1283: l_table_name po_interface_errors.table_name%TYPE;

Line 1280: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;

1276: l_qs NUMBER;
1277: l_atr NUMBER;
1278: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1279: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;
1280: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;
1281: l_revision rcv_transactions_interface.item_revision%TYPE;
1282: l_primary_qty NUMBER;
1283: l_table_name po_interface_errors.table_name%TYPE;
1284: BEGIN

Line 1303: FROM mtl_system_items msi,

1299: l_interface_id := p_interface_transaction_id;
1300:
1301: SELECT NVL(mp.negative_inv_receipt_code, -999)
1302: INTO l_negative_inv_receipt_code
1303: FROM mtl_system_items msi,
1304: mtl_parameters mp
1305: WHERE mp.organization_id = p_to_organization_id
1306: AND msi.organization_id = mp.organization_id
1307: AND msi.inventory_item_id = p_item_id;

Line 1324: FROM mtl_system_items msi

1320: msi.serial_number_control_code
1321: INTO l_revision_qty_control_code,
1322: l_lot_control_code,
1323: l_serial_number_control_code
1324: FROM mtl_system_items msi
1325: WHERE inventory_item_id = p_item_id
1326: AND NVL(msi.organization_id, p_to_organization_id) = p_to_organization_id;
1327:
1328: IF l_revision_qty_control_code <> '2' THEN