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_UI_ITEM_ATT_LOVS dependencies on MTL_CC_SUBINVENTORIES

Line 1194: FROM mtl_cc_subinventories

1190: AND (l_orientation_code = 1 OR
1191: (msn.current_status = 3
1192: AND msn.current_subinventory_code IN
1193: (SELECT subinventory
1194: FROM mtl_cc_subinventories
1195: WHERE cycle_count_header_id = p_cycle_count_header_id))
1196: OR msn.current_status <> 3
1197: )
1198: AND serial_number LIKE (p_serial_number)

Line 1427: FROM mtl_cc_subinventories

1423: AND (l_orientation_code = 1 OR
1424: (msn.current_status = 3
1425: AND msn.current_subinventory_code IN
1426: (SELECT subinventory
1427: FROM mtl_cc_subinventories
1428: WHERE cycle_count_header_id = p_cycle_count_header_id))
1429: OR msn.current_status <> 3
1430: )
1431: AND (NVL(msn.lot_number, '###') = NVL(p_lot_number, '###')

Line 1647: FROM mtl_cc_subinventories

1643: AND (l_orientation_code = 1 OR
1644: (msn.current_status = 3
1645: AND msn.current_subinventory_code IN
1646: (SELECT subinventory
1647: FROM mtl_cc_subinventories
1648: WHERE cycle_count_header_id = p_cycle_count_header_id))
1649: OR msn.current_status <> 3
1650: )
1651: AND msn.serial_number LIKE (p_serial_number)