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_MGD_POS_ITEM_MDTR dependencies on DUAL

Line 88: FROM dual where NOT EXISTS

84: BETWEEN NVL(p_item_from,concatenated_segments) AND NVL(p_item_to,concatenated_segments)
85: -- Following union clause added for bug 4357322
86: UNION
87: SELECT p_organization_id, -1
88: FROM dual where NOT EXISTS
89: ( SELECT 1 FROM mtl_system_items_kfv
90: WHERE organization_id = p_organization_id
91: AND concatenated_segments
92: BETWEEN NVL(p_item_from,concatenated_segments) AND NVL(p_item_to,concatenated_segments)

Line 126: FROM dual where NOT EXISTS

122: AND mic.category_id = p_category_id
123: -- Following union clause added for bug 4357322
124: UNION
125: SELECT p_organization_id, -1
126: FROM dual where NOT EXISTS
127: ( SELECT 1 FROM mtl_system_items_kfv msik, mtl_item_categories mic
128: WHERE msik.organization_id = p_organization_id
129: AND msik.concatenated_segments
130: BETWEEN NVL(p_item_from,msik.concatenated_segments)