APPS.WSM_SERIAL_SUPPORT_GRP dependencies on MTL_SERIAL_NUMBERS

Line 808: insert into mtl_serial_numbers_temp

804: l_stmt_num := 130;
805: if nvl(l_serial_txn_id,0) <> 0 then
806:
807: l_stmt_num := 140;
808: insert into mtl_serial_numbers_temp
809: (
810: TRANSACTION_TEMP_ID ,
811: LAST_UPDATE_DATE ,
812: LAST_UPDATED_BY ,

Line 999: mtl_serial_numbers MSN

995: MUT.ATTRIBUTE14 ,
996: MUT.ATTRIBUTE15 ,
997: decode(nvl(MUT.ATTRIBUTE_CATEGORY,-1),-1,'N','Y')
998: from mtl_unit_transactions MUT,
999: mtl_serial_numbers MSN
1000: where MUT.transaction_id = l_lot_txn_rec.serial_transaction_id
1001: and MUT.serial_number = MSN.serial_number
1002: and MSN.current_organization_id = MUT.ORGANIZATION_ID
1003: and msn.last_transaction_id = l_mmt_rec.transaction_id; --l_lot_txn_rec.serial_transaction_id;

Line 1025: insert into mtl_serial_numbers_temp

1021: if l_lot_controlled = 0 then
1022:
1023: l_stmt_num := 160;
1024: -- insert the records for serial controlled assemblies...
1025: insert into mtl_serial_numbers_temp
1026: (
1027: TRANSACTION_TEMP_ID ,
1028: LAST_UPDATE_DATE ,
1029: LAST_UPDATED_BY ,

Line 1218: mtl_serial_numbers MSN

1214: MUT.ATTRIBUTE15 ,
1215: decode(nvl(MUT.ATTRIBUTE_CATEGORY,-1),-1,'N','Y')
1216: -- PARENT_LOT_NUMBER
1217: from mtl_unit_transactions MUT,
1218: mtl_serial_numbers MSN
1219: where MUT.transaction_id = l_mmt_rec.transaction_id
1220: and MUT.serial_number = MSN.serial_number
1221: and MSN.current_organization_id = MUT.ORGANIZATION_ID
1222: and msn.last_transaction_id = l_mmt_rec.transaction_id;