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_TRANSACTION_LOTS_INTERFACE

Line 1973: -- MTL_TRANSACTION_LOTS_INTERFACE mtli, -- Bug 2576424 : joabraha

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,
1977: --MTL_TRANSACTION_LOTS_TEMP mtlt,

Line 1976: MTL_TRANSACTION_LOTS_INTERFACE mtli,

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,
1977: --MTL_TRANSACTION_LOTS_TEMP mtlt,
1978: MTL_SYSTEM_ITEMS msi,
1979: WIP_FLOW_SCHEDULES wfs
1980: WHERE mti.transaction_interface_id = l_transaction_id

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