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_STATUS_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 314: (select 1 from mtl_system_items_b msi

310: and nvl(lpn_id, -9999) = nvl(p_lpn_id, -9999) -- Bug 7012984, Modified the lpn_id condition
311: and nvl(lot_number, '@@@@') BETWEEN nvl (p_from_lot_number, Nvl(lot_number, '@@@@'))
312: and nvl (p_to_lot_number, Nvl(lot_number, '@@@@'))
313: and exists
314: (select 1 from mtl_system_items_b msi
315: where moqd.inventory_item_id = msi.inventory_item_id
316: AND moqd.organization_id = msi.organization_id
317: AND msi.serial_number_control_code in (1,6)
318: )

Line 332: (select 1 from mtl_system_items_b msi

328: and nvl(lot_number, '@@@@') BETWEEN nvl (p_from_lot_number, Nvl(lot_number, '@@@@'))
329: and nvl (p_to_lot_number, Nvl(lot_number, '@@@@'))
330: and current_status = 3
331: and exists
332: (select 1 from mtl_system_items_b msi
333: where msn.inventory_item_id = msi.inventory_item_id
334: AND msn.current_organization_id = msi.organization_id
335: AND nvl(msi.serial_status_enabled, 'N') = 'Y'
336: )