APPS.RCV_ROI_RETURN dependencies on MTL_SYSTEM_ITEMS

Line 1335: l_lot_control_code mtl_system_items.lot_control_code%TYPE;

1331: l_rqoh NUMBER;
1332: l_qr NUMBER;
1333: l_qs NUMBER;
1334: l_atr NUMBER;
1335: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1336: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;
1337: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;
1338: l_revision rcv_transactions_interface.item_revision%TYPE;
1339: l_primary_qty NUMBER;

Line 1336: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;

1332: l_qr NUMBER;
1333: l_qs NUMBER;
1334: l_atr NUMBER;
1335: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1336: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;
1337: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;
1338: l_revision rcv_transactions_interface.item_revision%TYPE;
1339: l_primary_qty NUMBER;
1340: l_table_name po_interface_errors.table_name%TYPE;

Line 1337: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;

1333: l_qs NUMBER;
1334: l_atr NUMBER;
1335: l_lot_control_code mtl_system_items.lot_control_code%TYPE;
1336: l_serial_number_control_code mtl_system_items.serial_number_control_code%TYPE;
1337: l_revision_qty_control_code mtl_system_items.revision_qty_control_code%TYPE;
1338: l_revision rcv_transactions_interface.item_revision%TYPE;
1339: l_primary_qty NUMBER;
1340: l_table_name po_interface_errors.table_name%TYPE;
1341: BEGIN

Line 1360: FROM mtl_system_items msi,

1356: l_interface_id := p_interface_transaction_id;
1357:
1358: SELECT NVL(mp.negative_inv_receipt_code, -999)
1359: INTO l_negative_inv_receipt_code
1360: FROM mtl_system_items msi,
1361: mtl_parameters mp
1362: WHERE mp.organization_id = p_to_organization_id
1363: AND msi.organization_id = mp.organization_id
1364: AND msi.inventory_item_id = p_item_id;

Line 1381: FROM mtl_system_items msi

1377: msi.serial_number_control_code
1378: INTO l_revision_qty_control_code,
1379: l_lot_control_code,
1380: l_serial_number_control_code
1381: FROM mtl_system_items msi
1382: WHERE inventory_item_id = p_item_id
1383: AND NVL(msi.organization_id, p_to_organization_id) = p_to_organization_id;
1384:
1385: IF l_revision_qty_control_code <> '2' THEN