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_LABEL_PVT10 dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1972: FROM MTL_TRANSACTIONS_INTERFACE mti,

1968: NVL(mti.schedule_number, wfs.schedule_number) schedule_number,
1969: msi.lot_control_code,
1970: msi.serial_number_control_code,
1971: mti.transaction_interface_id transaction_id
1972: FROM MTL_TRANSACTIONS_INTERFACE mti,
1973: -- MTL_TRANSACTION_LOTS_INTERFACE mtli, -- Bug 2576424 : joabraha
1974: -- Bug 2904877, change back to using MTLI,
1975: -- this depends on WIP's fix on bug 2904857
1976: MTL_TRANSACTION_LOTS_INTERFACE mtli,

Line 2219: FROM mtl_transactions_interface mti,

2215: -- Bug 2882958, added parameter p_lot_number to restrict on lot
2216: CURSOR mti_serial_curs(p_lot_number VARCHAR2) IS
2217: -- Serial Control
2218: SELECT msn.serial_number
2219: FROM mtl_transactions_interface mti,
2220: mtl_serial_numbers_interface msni, mtl_serial_numbers msn
2221: where mti.transaction_interface_id =msni.transaction_interface_id
2222: and msni.fm_serial_number <= msn.serial_number AND
2223: msni.to_serial_number >= msn.serial_number

Line 2230: FROM mtl_transactions_interface mti, mtl_transaction_lots_interface mtli,

2226: and mti.transaction_interface_id = l_transaction_id
2227: UNION
2228: -- Lot and Serial Control
2229: SELECT msn.serial_number
2230: FROM mtl_transactions_interface mti, mtl_transaction_lots_interface mtli,
2231: mtl_serial_numbers_interface msni, mtl_serial_numbers msn
2232: where mti.transaction_interface_id = mtli.transaction_interface_id
2233: and mtli.serial_transaction_temp_id = msni.transaction_interface_id
2234: and msni.fm_serial_number <= msn.serial_number AND