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 1089: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE

1085:
1086: /*----------------------------------------------------------------------------
1087: * PROCEDURE: insert_msni
1088: * Description:
1089: * This procedure inserts a record into MTL_SERIAL_NUMBERS_INTERFACE
1090: * Generate transaction_interface_id if the parameter is NULL
1091: * Generate product_transaction_id if the parameter is NULL
1092: * The insert logic is based on the parameter p_att_exist.
1093: * If p_att_exist is "N" Then (attributes are not available in table)

Line 1302: FROM mtl_serial_numbers

1298: , attribute12
1299: , attribute13
1300: , attribute14
1301: , attribute15
1302: FROM mtl_serial_numbers
1303: WHERE serial_number = v_serial_number
1304: AND inventory_item_id = v_inventory_item_id;
1305:
1306: TYPE msni_rec_tp IS RECORD (

Line 1307: fm_serial_number mtl_serial_numbers.serial_number%TYPE

1303: WHERE serial_number = v_serial_number
1304: AND inventory_item_id = v_inventory_item_id;
1305:
1306: TYPE msni_rec_tp IS RECORD (
1307: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE

Line 1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE

1304: AND inventory_item_id = v_inventory_item_id;
1305:
1306: TYPE msni_rec_tp IS RECORD (
1307: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE

Line 1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE

1305:
1306: TYPE msni_rec_tp IS RECORD (
1307: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE

Line 1310: , status_id mtl_serial_numbers.status_id%TYPE

1306: TYPE msni_rec_tp IS RECORD (
1307: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE

Line 1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE

1307: fm_serial_number mtl_serial_numbers.serial_number%TYPE
1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE

Line 1312: , product_code mtl_serial_numbers_interface.product_code%TYPE

1308: , to_serial_number mtl_serial_numbers.serial_number%TYPE
1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1316: , origination_date mtl_serial_numbers.origination_date%TYPE

Line 1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE

1309: , transaction_interface_id mtl_serial_numbers_interface.transaction_interface_id%TYPE
1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1316: , origination_date mtl_serial_numbers.origination_date%TYPE
1317: , territory_code mtl_serial_numbers.territory_code%TYPE

Line 1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE

1310: , status_id mtl_serial_numbers.status_id%TYPE
1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1316: , origination_date mtl_serial_numbers.origination_date%TYPE
1317: , territory_code mtl_serial_numbers.territory_code%TYPE
1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE

Line 1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE

1311: , product_transaction_id mtl_serial_numbers_interface.product_transaction_id%TYPE
1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1316: , origination_date mtl_serial_numbers.origination_date%TYPE
1317: , territory_code mtl_serial_numbers.territory_code%TYPE
1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE

Line 1316: , origination_date mtl_serial_numbers.origination_date%TYPE

1312: , product_code mtl_serial_numbers_interface.product_code%TYPE
1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1316: , origination_date mtl_serial_numbers.origination_date%TYPE
1317: , territory_code mtl_serial_numbers.territory_code%TYPE
1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE

Line 1317: , territory_code mtl_serial_numbers.territory_code%TYPE

1313: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1316: , origination_date mtl_serial_numbers.origination_date%TYPE
1317: , territory_code mtl_serial_numbers.territory_code%TYPE
1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE

Line 1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE

1314: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1316: , origination_date mtl_serial_numbers.origination_date%TYPE
1317: , territory_code mtl_serial_numbers.territory_code%TYPE
1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE

Line 1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE

1315: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
1316: , origination_date mtl_serial_numbers.origination_date%TYPE
1317: , territory_code mtl_serial_numbers.territory_code%TYPE
1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE

Line 1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE

1316: , origination_date mtl_serial_numbers.origination_date%TYPE
1317: , territory_code mtl_serial_numbers.territory_code%TYPE
1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE

Line 1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE

1317: , territory_code mtl_serial_numbers.territory_code%TYPE
1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE

Line 1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE

1318: , time_since_new mtl_serial_numbers.time_since_new%TYPE
1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE

Line 1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE

1319: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE

Line 1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE

1320: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE

Line 1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE

1321: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE

Line 1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE

1322: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE

Line 1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE

1323: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE

Line 1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE

1324: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE

Line 1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE

1325: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE

Line 1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE

1326: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE

Line 1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE

1327: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE

Line 1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE

1328: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE

Line 1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE

1329: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE

Line 1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE

1330: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE

Line 1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE

1331: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE

Line 1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE

1332: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE

Line 1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE

1333: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE

Line 1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE

1334: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE

Line 1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE

1335: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE

Line 1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE

1336: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE

Line 1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE

1337: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE

Line 1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE

1338: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE

Line 1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE

1339: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE

Line 1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE

1340: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE

Line 1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE

1341: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE

Line 1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE

1342: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE

Line 1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE

1343: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE

Line 1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE

1344: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE

Line 1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE

1345: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE

Line 1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE

1346: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE

Line 1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE

1347: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE

Line 1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE

1348: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE

Line 1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE

1349: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE

Line 1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE

1350: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE

Line 1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE

1351: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE

Line 1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE

1352: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE

Line 1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE

1353: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE

Line 1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE

1354: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE

Line 1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE

1355: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE

Line 1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE

1356: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE

Line 1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE

1357: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE

Line 1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE

1358: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE

Line 1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE

1359: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE

Line 1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE

1360: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE

Line 1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE

1361: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE

Line 1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE

1362: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE

Line 1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE

1363: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1371: , attribute1 mtl_serial_numbers.attribute1%TYPE

Line 1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE

1364: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1371: , attribute1 mtl_serial_numbers.attribute1%TYPE
1372: , attribute2 mtl_serial_numbers.attribute2%TYPE

Line 1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE

1365: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1371: , attribute1 mtl_serial_numbers.attribute1%TYPE
1372: , attribute2 mtl_serial_numbers.attribute2%TYPE
1373: , attribute3 mtl_serial_numbers.attribute3%TYPE

Line 1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE

1366: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1371: , attribute1 mtl_serial_numbers.attribute1%TYPE
1372: , attribute2 mtl_serial_numbers.attribute2%TYPE
1373: , attribute3 mtl_serial_numbers.attribute3%TYPE
1374: , attribute4 mtl_serial_numbers.attribute4%TYPE

Line 1371: , attribute1 mtl_serial_numbers.attribute1%TYPE

1367: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1371: , attribute1 mtl_serial_numbers.attribute1%TYPE
1372: , attribute2 mtl_serial_numbers.attribute2%TYPE
1373: , attribute3 mtl_serial_numbers.attribute3%TYPE
1374: , attribute4 mtl_serial_numbers.attribute4%TYPE
1375: , attribute5 mtl_serial_numbers.attribute5%TYPE

Line 1372: , attribute2 mtl_serial_numbers.attribute2%TYPE

1368: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1371: , attribute1 mtl_serial_numbers.attribute1%TYPE
1372: , attribute2 mtl_serial_numbers.attribute2%TYPE
1373: , attribute3 mtl_serial_numbers.attribute3%TYPE
1374: , attribute4 mtl_serial_numbers.attribute4%TYPE
1375: , attribute5 mtl_serial_numbers.attribute5%TYPE
1376: , attribute6 mtl_serial_numbers.attribute6%TYPE

Line 1373: , attribute3 mtl_serial_numbers.attribute3%TYPE

1369: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1371: , attribute1 mtl_serial_numbers.attribute1%TYPE
1372: , attribute2 mtl_serial_numbers.attribute2%TYPE
1373: , attribute3 mtl_serial_numbers.attribute3%TYPE
1374: , attribute4 mtl_serial_numbers.attribute4%TYPE
1375: , attribute5 mtl_serial_numbers.attribute5%TYPE
1376: , attribute6 mtl_serial_numbers.attribute6%TYPE
1377: , attribute7 mtl_serial_numbers.attribute7%TYPE

Line 1374: , attribute4 mtl_serial_numbers.attribute4%TYPE

1370: , attribute_category mtl_serial_numbers_interface.attribute_category%TYPE
1371: , attribute1 mtl_serial_numbers.attribute1%TYPE
1372: , attribute2 mtl_serial_numbers.attribute2%TYPE
1373: , attribute3 mtl_serial_numbers.attribute3%TYPE
1374: , attribute4 mtl_serial_numbers.attribute4%TYPE
1375: , attribute5 mtl_serial_numbers.attribute5%TYPE
1376: , attribute6 mtl_serial_numbers.attribute6%TYPE
1377: , attribute7 mtl_serial_numbers.attribute7%TYPE
1378: , attribute8 mtl_serial_numbers.attribute8%TYPE

Line 1375: , attribute5 mtl_serial_numbers.attribute5%TYPE

1371: , attribute1 mtl_serial_numbers.attribute1%TYPE
1372: , attribute2 mtl_serial_numbers.attribute2%TYPE
1373: , attribute3 mtl_serial_numbers.attribute3%TYPE
1374: , attribute4 mtl_serial_numbers.attribute4%TYPE
1375: , attribute5 mtl_serial_numbers.attribute5%TYPE
1376: , attribute6 mtl_serial_numbers.attribute6%TYPE
1377: , attribute7 mtl_serial_numbers.attribute7%TYPE
1378: , attribute8 mtl_serial_numbers.attribute8%TYPE
1379: , attribute9 mtl_serial_numbers.attribute9%TYPE

Line 1376: , attribute6 mtl_serial_numbers.attribute6%TYPE

1372: , attribute2 mtl_serial_numbers.attribute2%TYPE
1373: , attribute3 mtl_serial_numbers.attribute3%TYPE
1374: , attribute4 mtl_serial_numbers.attribute4%TYPE
1375: , attribute5 mtl_serial_numbers.attribute5%TYPE
1376: , attribute6 mtl_serial_numbers.attribute6%TYPE
1377: , attribute7 mtl_serial_numbers.attribute7%TYPE
1378: , attribute8 mtl_serial_numbers.attribute8%TYPE
1379: , attribute9 mtl_serial_numbers.attribute9%TYPE
1380: , attribute10 mtl_serial_numbers.attribute10%TYPE

Line 1377: , attribute7 mtl_serial_numbers.attribute7%TYPE

1373: , attribute3 mtl_serial_numbers.attribute3%TYPE
1374: , attribute4 mtl_serial_numbers.attribute4%TYPE
1375: , attribute5 mtl_serial_numbers.attribute5%TYPE
1376: , attribute6 mtl_serial_numbers.attribute6%TYPE
1377: , attribute7 mtl_serial_numbers.attribute7%TYPE
1378: , attribute8 mtl_serial_numbers.attribute8%TYPE
1379: , attribute9 mtl_serial_numbers.attribute9%TYPE
1380: , attribute10 mtl_serial_numbers.attribute10%TYPE
1381: , attribute11 mtl_serial_numbers.attribute11%TYPE

Line 1378: , attribute8 mtl_serial_numbers.attribute8%TYPE

1374: , attribute4 mtl_serial_numbers.attribute4%TYPE
1375: , attribute5 mtl_serial_numbers.attribute5%TYPE
1376: , attribute6 mtl_serial_numbers.attribute6%TYPE
1377: , attribute7 mtl_serial_numbers.attribute7%TYPE
1378: , attribute8 mtl_serial_numbers.attribute8%TYPE
1379: , attribute9 mtl_serial_numbers.attribute9%TYPE
1380: , attribute10 mtl_serial_numbers.attribute10%TYPE
1381: , attribute11 mtl_serial_numbers.attribute11%TYPE
1382: , attribute12 mtl_serial_numbers.attribute12%TYPE

Line 1379: , attribute9 mtl_serial_numbers.attribute9%TYPE

1375: , attribute5 mtl_serial_numbers.attribute5%TYPE
1376: , attribute6 mtl_serial_numbers.attribute6%TYPE
1377: , attribute7 mtl_serial_numbers.attribute7%TYPE
1378: , attribute8 mtl_serial_numbers.attribute8%TYPE
1379: , attribute9 mtl_serial_numbers.attribute9%TYPE
1380: , attribute10 mtl_serial_numbers.attribute10%TYPE
1381: , attribute11 mtl_serial_numbers.attribute11%TYPE
1382: , attribute12 mtl_serial_numbers.attribute12%TYPE
1383: , attribute13 mtl_serial_numbers.attribute13%TYPE

Line 1380: , attribute10 mtl_serial_numbers.attribute10%TYPE

1376: , attribute6 mtl_serial_numbers.attribute6%TYPE
1377: , attribute7 mtl_serial_numbers.attribute7%TYPE
1378: , attribute8 mtl_serial_numbers.attribute8%TYPE
1379: , attribute9 mtl_serial_numbers.attribute9%TYPE
1380: , attribute10 mtl_serial_numbers.attribute10%TYPE
1381: , attribute11 mtl_serial_numbers.attribute11%TYPE
1382: , attribute12 mtl_serial_numbers.attribute12%TYPE
1383: , attribute13 mtl_serial_numbers.attribute13%TYPE
1384: , attribute14 mtl_serial_numbers.attribute14%TYPE

Line 1381: , attribute11 mtl_serial_numbers.attribute11%TYPE

1377: , attribute7 mtl_serial_numbers.attribute7%TYPE
1378: , attribute8 mtl_serial_numbers.attribute8%TYPE
1379: , attribute9 mtl_serial_numbers.attribute9%TYPE
1380: , attribute10 mtl_serial_numbers.attribute10%TYPE
1381: , attribute11 mtl_serial_numbers.attribute11%TYPE
1382: , attribute12 mtl_serial_numbers.attribute12%TYPE
1383: , attribute13 mtl_serial_numbers.attribute13%TYPE
1384: , attribute14 mtl_serial_numbers.attribute14%TYPE
1385: , attribute15 mtl_serial_numbers.attribute15%TYPE

Line 1382: , attribute12 mtl_serial_numbers.attribute12%TYPE

1378: , attribute8 mtl_serial_numbers.attribute8%TYPE
1379: , attribute9 mtl_serial_numbers.attribute9%TYPE
1380: , attribute10 mtl_serial_numbers.attribute10%TYPE
1381: , attribute11 mtl_serial_numbers.attribute11%TYPE
1382: , attribute12 mtl_serial_numbers.attribute12%TYPE
1383: , attribute13 mtl_serial_numbers.attribute13%TYPE
1384: , attribute14 mtl_serial_numbers.attribute14%TYPE
1385: , attribute15 mtl_serial_numbers.attribute15%TYPE
1386: );

Line 1383: , attribute13 mtl_serial_numbers.attribute13%TYPE

1379: , attribute9 mtl_serial_numbers.attribute9%TYPE
1380: , attribute10 mtl_serial_numbers.attribute10%TYPE
1381: , attribute11 mtl_serial_numbers.attribute11%TYPE
1382: , attribute12 mtl_serial_numbers.attribute12%TYPE
1383: , attribute13 mtl_serial_numbers.attribute13%TYPE
1384: , attribute14 mtl_serial_numbers.attribute14%TYPE
1385: , attribute15 mtl_serial_numbers.attribute15%TYPE
1386: );
1387:

Line 1384: , attribute14 mtl_serial_numbers.attribute14%TYPE

1380: , attribute10 mtl_serial_numbers.attribute10%TYPE
1381: , attribute11 mtl_serial_numbers.attribute11%TYPE
1382: , attribute12 mtl_serial_numbers.attribute12%TYPE
1383: , attribute13 mtl_serial_numbers.attribute13%TYPE
1384: , attribute14 mtl_serial_numbers.attribute14%TYPE
1385: , attribute15 mtl_serial_numbers.attribute15%TYPE
1386: );
1387:
1388: TYPE msni_rec_tbl_tp IS TABLE OF msni_rec_tp

Line 1385: , attribute15 mtl_serial_numbers.attribute15%TYPE

1381: , attribute11 mtl_serial_numbers.attribute11%TYPE
1382: , attribute12 mtl_serial_numbers.attribute12%TYPE
1383: , attribute13 mtl_serial_numbers.attribute13%TYPE
1384: , attribute14 mtl_serial_numbers.attribute14%TYPE
1385: , attribute15 mtl_serial_numbers.attribute15%TYPE
1386: );
1387:
1388: TYPE msni_rec_tbl_tp IS TABLE OF msni_rec_tp
1389: INDEX BY BINARY_INTEGER;

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

1391: --Local Variables
1392: l_msni_rec_tbl msni_rec_tbl_tp; --Table to hold each MSNI record inserted
1393: l_transaction_interface_id NUMBER; --transaction_interface_id generated
1394: l_product_transaction_id NUMBER; --product_transaction_id generated
1395: l_fm_serial_number mtl_serial_numbers.serial_number%TYPE := p_fm_serial_number;
1396: l_to_serial_number mtl_serial_numbers.serial_number%TYPE := p_to_serial_number;
1397: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;
1398: l_serial_prefix VARCHAR2(30); --serial number prefix
1399: l_from_ser_number NUMBER; --numberic part of from serial number

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

1392: l_msni_rec_tbl msni_rec_tbl_tp; --Table to hold each MSNI record inserted
1393: l_transaction_interface_id NUMBER; --transaction_interface_id generated
1394: l_product_transaction_id NUMBER; --product_transaction_id generated
1395: l_fm_serial_number mtl_serial_numbers.serial_number%TYPE := p_fm_serial_number;
1396: l_to_serial_number mtl_serial_numbers.serial_number%TYPE := p_to_serial_number;
1397: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;
1398: l_serial_prefix VARCHAR2(30); --serial number prefix
1399: l_from_ser_number NUMBER; --numberic part of from serial number
1400: l_to_ser_number NUMBER; --numeric part of to serial number

Line 1397: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;

1393: l_transaction_interface_id NUMBER; --transaction_interface_id generated
1394: l_product_transaction_id NUMBER; --product_transaction_id generated
1395: l_fm_serial_number mtl_serial_numbers.serial_number%TYPE := p_fm_serial_number;
1396: l_to_serial_number mtl_serial_numbers.serial_number%TYPE := p_to_serial_number;
1397: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;
1398: l_serial_prefix VARCHAR2(30); --serial number prefix
1399: l_from_ser_number NUMBER; --numberic part of from serial number
1400: l_to_ser_number NUMBER; --numeric part of to serial number
1401: l_cur_ser_num NUMBER; --numeric part of current serial part

Line 1408: l_source_code mtl_serial_numbers_interface.source_code%TYPE;

1404: l_range_numbers NUMBER; --no. of serial numbers in the range
1405: l_msni_tbl_count NUMBER; --Count of records to be inserted
1406: l_user_id NUMBER := fnd_global.user_id;
1407: l_login_id NUMBER := fnd_global.login_id;
1408: l_source_code mtl_serial_numbers_interface.source_code%TYPE;
1409: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;
1410: l_api_version CONSTANT NUMBER := 1.0;
1411: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
1412: l_success NUMBER;

Line 1409: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;

1405: l_msni_tbl_count NUMBER; --Count of records to be inserted
1406: l_user_id NUMBER := fnd_global.user_id;
1407: l_login_id NUMBER := fnd_global.login_id;
1408: l_source_code mtl_serial_numbers_interface.source_code%TYPE;
1409: l_source_line_id mtl_serial_numbers_interface.source_line_id%TYPE;
1410: l_api_version CONSTANT NUMBER := 1.0;
1411: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
1412: l_success NUMBER;
1413: l_progress NUMBER; --Progress Indicator

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

1577: END LOOP; --END For each serial number in the range
1578: END IF; --END IF p_att_exist = 'N'
1579:
1580: --At this stage, we have a PL/SQL table containing one or more rows to be
1581: --inserted into MTL_SERIAL_NUMBERS_INTERFACE. Loop through the table and
1582: --insert each record
1583: l_msni_tbl_count := l_msni_rec_tbl.COUNT;
1584:
1585: IF (l_debug = 1) THEN

Line 1598: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (

1594: END IF;
1595:
1596: FOR i IN 1 .. l_msni_tbl_count LOOP
1597:
1598: INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE (
1599: transaction_interface_id
1600: , source_code
1601: , source_line_id
1602: , last_update_date

Line 1776: UPDATE mtl_serial_numbers

1772: , l_msni_rec_tbl(i).attribute15
1773: );
1774: --If the flag p_update_msn is set then update MSN with the attributes
1775: IF (NVL(p_update_msn, 'N') = 'Y') THEN
1776: UPDATE mtl_serial_numbers
1777: SET vendor_serial_number = l_msni_rec_tbl(i).vendor_serial_number
1778: , vendor_lot_number = l_msni_rec_tbl(i).vendor_lot_number
1779: , parent_serial_number = l_msni_rec_tbl(i).parent_serial_number
1780: , origination_date = l_msni_rec_tbl(i).origination_date

Line 2239: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;

2235: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2236: l_serial_diff NUMBER := 0;
2237: l_serial_qty NUMBER := 0;
2238: l_serial_prefix VARCHAR2(30);
2239: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;
2240: l_from_ser_number NUMBER;
2241: l_to_ser_number NUMBER;
2242: l_cur_ser_num NUMBER;
2243: l_ser_num_length NUMBER;

Line 2249: l_to_serial_number mtl_serial_numbers.serial_number%TYPE; --Bug 8413853

2245: l_range_numbers NUMBER;
2246: l_serial_exists VARCHAR2(1);
2247: l_return NUMBER;
2248: --Bug 11708191 Modified the type of the bleow parameter to the msn.serial_number type.
2249: l_to_serial_number mtl_serial_numbers.serial_number%TYPE; --Bug 8413853
2250: BEGIN
2251: x_return_status := g_ret_sts_success;
2252:
2253: fnd_msg_pub.initialize;

Line 2366: FROM mtl_serial_numbers

2362: LPAD(l_cur_ser_num, l_ser_num_length - NVL(l_prefix_length,0), '0');
2363: BEGIN
2364: SELECT 'Y'
2365: INTO l_serial_exists
2366: FROM mtl_serial_numbers
2367: WHERE inventory_item_id = p_inventory_item_id
2368: AND serial_number = l_cur_serial_number
2369: AND current_organization_id = p_org_id
2370: AND current_status IN (1,6);