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.WSM_SERIAL_SUPPORT_GRP dependencies on MTL_SERIAL_NUMBERS

Line 802: insert into mtl_serial_numbers_temp

798: l_stmt_num := 130;
799: if nvl(l_serial_txn_id,0) <> 0 then
800:
801: l_stmt_num := 140;
802: insert into mtl_serial_numbers_temp
803: (
804: TRANSACTION_TEMP_ID ,
805: LAST_UPDATE_DATE ,
806: LAST_UPDATED_BY ,

Line 993: mtl_serial_numbers MSN

989: MUT.ATTRIBUTE14 ,
990: MUT.ATTRIBUTE15 ,
991: decode(nvl(MUT.ATTRIBUTE_CATEGORY,-1),-1,'N','Y')
992: from mtl_unit_transactions MUT,
993: mtl_serial_numbers MSN
994: where MUT.transaction_id = l_lot_txn_rec.serial_transaction_id
995: and MUT.serial_number = MSN.serial_number
996: and MSN.current_organization_id = MUT.ORGANIZATION_ID
997: and msn.last_transaction_id = l_mmt_rec.transaction_id; --l_lot_txn_rec.serial_transaction_id;

Line 1019: insert into mtl_serial_numbers_temp

1015: if l_lot_controlled = 0 then
1016:
1017: l_stmt_num := 160;
1018: -- insert the records for serial controlled assemblies...
1019: insert into mtl_serial_numbers_temp
1020: (
1021: TRANSACTION_TEMP_ID ,
1022: LAST_UPDATE_DATE ,
1023: LAST_UPDATED_BY ,

Line 1212: mtl_serial_numbers MSN

1208: MUT.ATTRIBUTE15 ,
1209: decode(nvl(MUT.ATTRIBUTE_CATEGORY,-1),-1,'N','Y')
1210: -- PARENT_LOT_NUMBER
1211: from mtl_unit_transactions MUT,
1212: mtl_serial_numbers MSN
1213: where MUT.transaction_id = l_mmt_rec.transaction_id
1214: and MUT.serial_number = MSN.serial_number
1215: and MSN.current_organization_id = MUT.ORGANIZATION_ID
1216: and msn.last_transaction_id = l_mmt_rec.transaction_id;