eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_SERIAL_NUMBERS

Line 1073: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE

1069:
1070: /*----------------------------------------------------------------------------
1071: * PROCEDURE: insert_msni
1072: * Description:
1073: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE
1074: * Generate transaction_interface_id if the parameter is NULL
1075: * Generate product_transaction_id if the parameter is NULL
1076: * The insert logic is based on the parameter p_att_exist.
1077: * If p_att_exist is "N" Then (attributes are not available in table)

Line 1286: FROM mtl_serial_numbers

1282: , attribute12
1283: , attribute13
1284: , attribute14
1285: , attribute15
1286: FROM mtl_serial_numbers
1287: WHERE serial_number = v_serial_number
1288: AND inventory_item_id = v_inventory_item_id;
1289:
1290: TYPE msni_rec_tp IS RECORD (

Line 1291: fm_serial_number mtl_serial_numbers.serial_number%TYPE

1287: WHERE serial_number = v_serial_number
1288: AND inventory_item_id = v_inventory_item_id;
1289:
1290: TYPE msni_rec_tp IS RECORD (
1291: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE

Line 1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE

1288: AND inventory_item_id = v_inventory_item_id;
1289:
1290: TYPE msni_rec_tp IS RECORD (
1291: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE

Line 1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE

1289:
1290: TYPE msni_rec_tp IS RECORD (
1291: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE

Line 1294: , status_id mtl_serial_numbers.status_id%TYPE

1290: TYPE msni_rec_tp IS RECORD (
1291: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE

Line 1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE

1291: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE

Line 1296: , product_code mtl_serial_numbers_interface.product_code%TYPE

1292: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1300: , origination_date mtl_serial_numbers.origination_date%TYPE

Line 1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE

1293: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1300: , origination_date mtl_serial_numbers.origination_date%TYPE
1301: , territory_code mtl_serial_numbers.territory_code%TYPE

Line 1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE

1294: , status_id mtl_serial_numbers.status_id%TYPE
1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1300: , origination_date mtl_serial_numbers.origination_date%TYPE
1301: , territory_code mtl_serial_numbers.territory_code%TYPE
1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE

Line 1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE

1295: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1300: , origination_date mtl_serial_numbers.origination_date%TYPE
1301: , territory_code mtl_serial_numbers.territory_code%TYPE
1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE

Line 1300: , origination_date mtl_serial_numbers.origination_date%TYPE

1296: , product_code mtl_serial_numbers_interface.product_code%TYPE
1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1300: , origination_date mtl_serial_numbers.origination_date%TYPE
1301: , territory_code mtl_serial_numbers.territory_code%TYPE
1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE

Line 1301: , territory_code mtl_serial_numbers.territory_code%TYPE

1297: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1300: , origination_date mtl_serial_numbers.origination_date%TYPE
1301: , territory_code mtl_serial_numbers.territory_code%TYPE
1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE

Line 1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE

1298: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1300: , origination_date mtl_serial_numbers.origination_date%TYPE
1301: , territory_code mtl_serial_numbers.territory_code%TYPE
1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE

Line 1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE

1299: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1300: , origination_date mtl_serial_numbers.origination_date%TYPE
1301: , territory_code mtl_serial_numbers.territory_code%TYPE
1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE

Line 1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE

1300: , origination_date mtl_serial_numbers.origination_date%TYPE
1301: , territory_code mtl_serial_numbers.territory_code%TYPE
1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE

Line 1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE

1301: , territory_code mtl_serial_numbers.territory_code%TYPE
1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE

Line 1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE

1302: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE

Line 1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE

1303: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE

Line 1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE

1304: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE

Line 1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE

1305: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE

Line 1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE

1306: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE

Line 1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE

1307: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE

Line 1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE

1308: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE

Line 1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE

1309: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE

Line 1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE

1310: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE

Line 1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE

1311: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE

Line 1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE

1312: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE

Line 1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE

1313: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE

Line 1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE

1314: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE

Line 1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE

1315: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE

Line 1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE

1316: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE

Line 1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE

1317: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE

Line 1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE

1318: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE

Line 1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE

1319: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE

Line 1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE

1320: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE

Line 1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE

1321: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE

Line 1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE

1322: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE

Line 1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE

1323: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE

Line 1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE

1324: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE

Line 1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE

1325: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE

Line 1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE

1326: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE

Line 1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE

1327: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE

Line 1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE

1328: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE

Line 1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE

1329: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE

Line 1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE

1330: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE

Line 1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE

1331: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE

Line 1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE

1332: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE

Line 1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE

1333: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE

Line 1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE

1334: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE

Line 1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE

1335: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE

Line 1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE

1336: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE

Line 1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE

1337: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE

Line 1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE

1338: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE

Line 1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE

1339: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE

Line 1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE

1340: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE

Line 1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE

1341: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE

Line 1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE

1342: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE

Line 1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE

1343: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE

Line 1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE

1344: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE

Line 1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE

1345: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE

Line 1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE

1346: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE

Line 1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE

1347: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1355: , attribute1 mtl_serial_numbers.attribute1%TYPE

Line 1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE

1348: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1355: , attribute1 mtl_serial_numbers.attribute1%TYPE
1356: , attribute2 mtl_serial_numbers.attribute2%TYPE

Line 1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE

1349: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1355: , attribute1 mtl_serial_numbers.attribute1%TYPE
1356: , attribute2 mtl_serial_numbers.attribute2%TYPE
1357: , attribute3 mtl_serial_numbers.attribute3%TYPE

Line 1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE

1350: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1355: , attribute1 mtl_serial_numbers.attribute1%TYPE
1356: , attribute2 mtl_serial_numbers.attribute2%TYPE
1357: , attribute3 mtl_serial_numbers.attribute3%TYPE
1358: , attribute4 mtl_serial_numbers.attribute4%TYPE

Line 1355: , attribute1 mtl_serial_numbers.attribute1%TYPE

1351: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1355: , attribute1 mtl_serial_numbers.attribute1%TYPE
1356: , attribute2 mtl_serial_numbers.attribute2%TYPE
1357: , attribute3 mtl_serial_numbers.attribute3%TYPE
1358: , attribute4 mtl_serial_numbers.attribute4%TYPE
1359: , attribute5 mtl_serial_numbers.attribute5%TYPE

Line 1356: , attribute2 mtl_serial_numbers.attribute2%TYPE

1352: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1355: , attribute1 mtl_serial_numbers.attribute1%TYPE
1356: , attribute2 mtl_serial_numbers.attribute2%TYPE
1357: , attribute3 mtl_serial_numbers.attribute3%TYPE
1358: , attribute4 mtl_serial_numbers.attribute4%TYPE
1359: , attribute5 mtl_serial_numbers.attribute5%TYPE
1360: , attribute6 mtl_serial_numbers.attribute6%TYPE

Line 1357: , attribute3 mtl_serial_numbers.attribute3%TYPE

1353: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1355: , attribute1 mtl_serial_numbers.attribute1%TYPE
1356: , attribute2 mtl_serial_numbers.attribute2%TYPE
1357: , attribute3 mtl_serial_numbers.attribute3%TYPE
1358: , attribute4 mtl_serial_numbers.attribute4%TYPE
1359: , attribute5 mtl_serial_numbers.attribute5%TYPE
1360: , attribute6 mtl_serial_numbers.attribute6%TYPE
1361: , attribute7 mtl_serial_numbers.attribute7%TYPE

Line 1358: , attribute4 mtl_serial_numbers.attribute4%TYPE

1354: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1355: , attribute1 mtl_serial_numbers.attribute1%TYPE
1356: , attribute2 mtl_serial_numbers.attribute2%TYPE
1357: , attribute3 mtl_serial_numbers.attribute3%TYPE
1358: , attribute4 mtl_serial_numbers.attribute4%TYPE
1359: , attribute5 mtl_serial_numbers.attribute5%TYPE
1360: , attribute6 mtl_serial_numbers.attribute6%TYPE
1361: , attribute7 mtl_serial_numbers.attribute7%TYPE
1362: , attribute8 mtl_serial_numbers.attribute8%TYPE

Line 1359: , attribute5 mtl_serial_numbers.attribute5%TYPE

1355: , attribute1 mtl_serial_numbers.attribute1%TYPE
1356: , attribute2 mtl_serial_numbers.attribute2%TYPE
1357: , attribute3 mtl_serial_numbers.attribute3%TYPE
1358: , attribute4 mtl_serial_numbers.attribute4%TYPE
1359: , attribute5 mtl_serial_numbers.attribute5%TYPE
1360: , attribute6 mtl_serial_numbers.attribute6%TYPE
1361: , attribute7 mtl_serial_numbers.attribute7%TYPE
1362: , attribute8 mtl_serial_numbers.attribute8%TYPE
1363: , attribute9 mtl_serial_numbers.attribute9%TYPE

Line 1360: , attribute6 mtl_serial_numbers.attribute6%TYPE

1356: , attribute2 mtl_serial_numbers.attribute2%TYPE
1357: , attribute3 mtl_serial_numbers.attribute3%TYPE
1358: , attribute4 mtl_serial_numbers.attribute4%TYPE
1359: , attribute5 mtl_serial_numbers.attribute5%TYPE
1360: , attribute6 mtl_serial_numbers.attribute6%TYPE
1361: , attribute7 mtl_serial_numbers.attribute7%TYPE
1362: , attribute8 mtl_serial_numbers.attribute8%TYPE
1363: , attribute9 mtl_serial_numbers.attribute9%TYPE
1364: , attribute10 mtl_serial_numbers.attribute10%TYPE

Line 1361: , attribute7 mtl_serial_numbers.attribute7%TYPE

1357: , attribute3 mtl_serial_numbers.attribute3%TYPE
1358: , attribute4 mtl_serial_numbers.attribute4%TYPE
1359: , attribute5 mtl_serial_numbers.attribute5%TYPE
1360: , attribute6 mtl_serial_numbers.attribute6%TYPE
1361: , attribute7 mtl_serial_numbers.attribute7%TYPE
1362: , attribute8 mtl_serial_numbers.attribute8%TYPE
1363: , attribute9 mtl_serial_numbers.attribute9%TYPE
1364: , attribute10 mtl_serial_numbers.attribute10%TYPE
1365: , attribute11 mtl_serial_numbers.attribute11%TYPE

Line 1362: , attribute8 mtl_serial_numbers.attribute8%TYPE

1358: , attribute4 mtl_serial_numbers.attribute4%TYPE
1359: , attribute5 mtl_serial_numbers.attribute5%TYPE
1360: , attribute6 mtl_serial_numbers.attribute6%TYPE
1361: , attribute7 mtl_serial_numbers.attribute7%TYPE
1362: , attribute8 mtl_serial_numbers.attribute8%TYPE
1363: , attribute9 mtl_serial_numbers.attribute9%TYPE
1364: , attribute10 mtl_serial_numbers.attribute10%TYPE
1365: , attribute11 mtl_serial_numbers.attribute11%TYPE
1366: , attribute12 mtl_serial_numbers.attribute12%TYPE

Line 1363: , attribute9 mtl_serial_numbers.attribute9%TYPE

1359: , attribute5 mtl_serial_numbers.attribute5%TYPE
1360: , attribute6 mtl_serial_numbers.attribute6%TYPE
1361: , attribute7 mtl_serial_numbers.attribute7%TYPE
1362: , attribute8 mtl_serial_numbers.attribute8%TYPE
1363: , attribute9 mtl_serial_numbers.attribute9%TYPE
1364: , attribute10 mtl_serial_numbers.attribute10%TYPE
1365: , attribute11 mtl_serial_numbers.attribute11%TYPE
1366: , attribute12 mtl_serial_numbers.attribute12%TYPE
1367: , attribute13 mtl_serial_numbers.attribute13%TYPE

Line 1364: , attribute10 mtl_serial_numbers.attribute10%TYPE

1360: , attribute6 mtl_serial_numbers.attribute6%TYPE
1361: , attribute7 mtl_serial_numbers.attribute7%TYPE
1362: , attribute8 mtl_serial_numbers.attribute8%TYPE
1363: , attribute9 mtl_serial_numbers.attribute9%TYPE
1364: , attribute10 mtl_serial_numbers.attribute10%TYPE
1365: , attribute11 mtl_serial_numbers.attribute11%TYPE
1366: , attribute12 mtl_serial_numbers.attribute12%TYPE
1367: , attribute13 mtl_serial_numbers.attribute13%TYPE
1368: , attribute14 mtl_serial_numbers.attribute14%TYPE

Line 1365: , attribute11 mtl_serial_numbers.attribute11%TYPE

1361: , attribute7 mtl_serial_numbers.attribute7%TYPE
1362: , attribute8 mtl_serial_numbers.attribute8%TYPE
1363: , attribute9 mtl_serial_numbers.attribute9%TYPE
1364: , attribute10 mtl_serial_numbers.attribute10%TYPE
1365: , attribute11 mtl_serial_numbers.attribute11%TYPE
1366: , attribute12 mtl_serial_numbers.attribute12%TYPE
1367: , attribute13 mtl_serial_numbers.attribute13%TYPE
1368: , attribute14 mtl_serial_numbers.attribute14%TYPE
1369: , attribute15 mtl_serial_numbers.attribute15%TYPE

Line 1366: , attribute12 mtl_serial_numbers.attribute12%TYPE

1362: , attribute8 mtl_serial_numbers.attribute8%TYPE
1363: , attribute9 mtl_serial_numbers.attribute9%TYPE
1364: , attribute10 mtl_serial_numbers.attribute10%TYPE
1365: , attribute11 mtl_serial_numbers.attribute11%TYPE
1366: , attribute12 mtl_serial_numbers.attribute12%TYPE
1367: , attribute13 mtl_serial_numbers.attribute13%TYPE
1368: , attribute14 mtl_serial_numbers.attribute14%TYPE
1369: , attribute15 mtl_serial_numbers.attribute15%TYPE
1370: );

Line 1367: , attribute13 mtl_serial_numbers.attribute13%TYPE

1363: , attribute9 mtl_serial_numbers.attribute9%TYPE
1364: , attribute10 mtl_serial_numbers.attribute10%TYPE
1365: , attribute11 mtl_serial_numbers.attribute11%TYPE
1366: , attribute12 mtl_serial_numbers.attribute12%TYPE
1367: , attribute13 mtl_serial_numbers.attribute13%TYPE
1368: , attribute14 mtl_serial_numbers.attribute14%TYPE
1369: , attribute15 mtl_serial_numbers.attribute15%TYPE
1370: );
1371:

Line 1368: , attribute14 mtl_serial_numbers.attribute14%TYPE

1364: , attribute10 mtl_serial_numbers.attribute10%TYPE
1365: , attribute11 mtl_serial_numbers.attribute11%TYPE
1366: , attribute12 mtl_serial_numbers.attribute12%TYPE
1367: , attribute13 mtl_serial_numbers.attribute13%TYPE
1368: , attribute14 mtl_serial_numbers.attribute14%TYPE
1369: , attribute15 mtl_serial_numbers.attribute15%TYPE
1370: );
1371:
1372: TYPE msni_rec_tbl_tp IS TABLE OF msni_rec_tp

Line 1369: , attribute15 mtl_serial_numbers.attribute15%TYPE

1365: , attribute11 mtl_serial_numbers.attribute11%TYPE
1366: , attribute12 mtl_serial_numbers.attribute12%TYPE
1367: , attribute13 mtl_serial_numbers.attribute13%TYPE
1368: , attribute14 mtl_serial_numbers.attribute14%TYPE
1369: , attribute15 mtl_serial_numbers.attribute15%TYPE
1370: );
1371:
1372: TYPE msni_rec_tbl_tp IS TABLE OF msni_rec_tp
1373: INDEX BY BINARY_INTEGER;

Line 1379: l_fm_serial_number mtl_serial_numbers.serial_number%TYPE := p_fm_serial_number;

1375: --Local Variables
1376: l_msni_rec_tbl msni_rec_tbl_tp; --Table to hold each MSNI record inserted
1377: l_transaction_interface_id NUMBER; --transaction_interface_id generated
1378: l_product_transaction_id NUMBER; --product_transaction_id generated
1379: l_fm_serial_number mtl_serial_numbers.serial_number%TYPE := p_fm_serial_number;
1380: l_to_serial_number mtl_serial_numbers.serial_number%TYPE := p_to_serial_number;
1381: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;
1382: l_serial_prefix VARCHAR2(30); --serial number prefix
1383: l_from_ser_number NUMBER; --numberic part of from serial number

Line 1380: l_to_serial_number mtl_serial_numbers.serial_number%TYPE := p_to_serial_number;

1376: l_msni_rec_tbl msni_rec_tbl_tp; --Table to hold each MSNI record inserted
1377: l_transaction_interface_id NUMBER; --transaction_interface_id generated
1378: l_product_transaction_id NUMBER; --product_transaction_id generated
1379: l_fm_serial_number mtl_serial_numbers.serial_number%TYPE := p_fm_serial_number;
1380: l_to_serial_number mtl_serial_numbers.serial_number%TYPE := p_to_serial_number;
1381: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;
1382: l_serial_prefix VARCHAR2(30); --serial number prefix
1383: l_from_ser_number NUMBER; --numberic part of from serial number
1384: l_to_ser_number NUMBER; --numeric part of to serial number

Line 1381: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;

1377: l_transaction_interface_id NUMBER; --transaction_interface_id generated
1378: l_product_transaction_id NUMBER; --product_transaction_id generated
1379: l_fm_serial_number mtl_serial_numbers.serial_number%TYPE := p_fm_serial_number;
1380: l_to_serial_number mtl_serial_numbers.serial_number%TYPE := p_to_serial_number;
1381: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;
1382: l_serial_prefix VARCHAR2(30); --serial number prefix
1383: l_from_ser_number NUMBER; --numberic part of from serial number
1384: l_to_ser_number NUMBER; --numeric part of to serial number
1385: l_cur_ser_num NUMBER; --numeric part of current serial part

Line 1392: l_source_code mtl_serial_numbers_interface.source_code%TYPE;

1388: l_range_numbers NUMBER; --no. of serial numbers in the range
1389: l_msni_tbl_count NUMBER; --Count of records to be inserted
1390: l_user_id NUMBER := fnd_global.user_id;
1391: l_login_id NUMBER := fnd_global.login_id;
1392: l_source_code mtl_serial_numbers_interface.source_code%TYPE;
1393: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;
1394: l_api_version CONSTANT NUMBER := 1.0;
1395: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
1396: l_success NUMBER;

Line 1393: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;

1389: l_msni_tbl_count NUMBER; --Count of records to be inserted
1390: l_user_id NUMBER := fnd_global.user_id;
1391: l_login_id NUMBER := fnd_global.login_id;
1392: l_source_code mtl_serial_numbers_interface.source_code%TYPE;
1393: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;
1394: l_api_version CONSTANT NUMBER := 1.0;
1395: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
1396: l_success NUMBER;
1397: l_progress NUMBER; --Progress Indicator

Line 1565: --inserted into MTL_SERIAL_NUMBERS_INTERFACE. Loop through the table and

1561: END LOOP; --END For each serial number in the range
1562: END IF; --END IF p_att_exist = 'N'
1563:
1564: --At this stage, we have a PL/SQL table containing one or more rows to be
1565: --inserted into MTL_SERIAL_NUMBERS_INTERFACE. Loop through the table and
1566: --insert each record
1567: l_msni_tbl_count := l_msni_rec_tbl.COUNT;
1568:
1569: IF (l_debug = 1) THEN

Line 1582: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

1578: END IF;
1579:
1580: FOR i IN 1 .. l_msni_tbl_count LOOP
1581:
1582: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
1583: transaction_interface_id
1584: , source_code
1585: , source_line_id
1586: , last_update_date

Line 1760: UPDATE mtl_serial_numbers

1756: , l_msni_rec_tbl(i).attribute15
1757: );
1758: --If the flag p_update_msn is set then update MSN with the attributes
1759: IF (NVL(p_update_msn, 'N') = 'Y') THEN
1760: UPDATE mtl_serial_numbers
1761: SET vendor_serial_number = l_msni_rec_tbl(i).vendor_serial_number
1762: , vendor_lot_number = l_msni_rec_tbl(i).vendor_lot_number
1763: , parent_serial_number = l_msni_rec_tbl(i).parent_serial_number
1764: , origination_date = l_msni_rec_tbl(i).origination_date

Line 2223: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;

2219: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2220: l_serial_diff NUMBER := 0;
2221: l_serial_qty NUMBER := 0;
2222: l_serial_prefix VARCHAR2(30);
2223: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;
2224: l_from_ser_number NUMBER;
2225: l_to_ser_number NUMBER;
2226: l_cur_ser_num NUMBER;
2227: l_ser_num_length NUMBER;

Line 2348: FROM mtl_serial_numbers

2344: LPAD(l_cur_ser_num, l_ser_num_length - NVL(l_prefix_length,0), '0');
2345: BEGIN
2346: SELECT 'Y'
2347: INTO l_serial_exists
2348: FROM mtl_serial_numbers
2349: WHERE inventory_item_id = p_inventory_item_id
2350: AND serial_number = l_cur_serial_number
2351: AND current_organization_id = p_org_id
2352: AND current_status IN (1,6);