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.CSI_WIP_TRXS_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 801: mtl_system_items_b msib

797: --Changed for Bug 12636010
798: SELECT msn.serial_number child_serial_number
799: FROM mtl_object_genealogy mog,
800: mtl_serial_numbers msn,
801: mtl_system_items_b msib
802: WHERE mog.parent_object_type = 2
803: AND msib.inventory_item_id = msn.inventory_item_id
804: AND msib.organization_id = msn.current_organization_id
805: AND nvl(msib.comms_nl_trackable_flag, 'N') = 'Y'

Line 2174: mtl_system_items_b msib

2170: SELECT msn.serial_number child_serial_number,
2171: msn.inventory_item_id child_item_id
2172: FROM mtl_object_genealogy mog,
2173: mtl_serial_numbers msn,
2174: mtl_system_items_b msib
2175: WHERE mog.parent_object_type = 2
2176: AND msib.inventory_item_id = msn.inventory_item_id
2177: AND msib.organization_id = msn.current_organization_id
2178: AND nvl(msib.comms_nl_trackable_flag, 'N') = 'Y'

Line 2301: mtl_system_items_b msib

2297: INTO l_parent_serial_number,
2298: l_parent_item_id
2299: FROM mtl_object_genealogy mog,
2300: mtl_serial_numbers msn,
2301: mtl_system_items_b msib
2302: WHERE mog.object_type = 2 -- serial genealogy
2303: AND msib.inventory_item_id = msn.inventory_item_id
2304: AND msib.organization_id = msn.current_organization_id
2305: AND nvl(msib.comms_nl_trackable_flag, 'N') = 'Y'