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 87: FROM dual where NOT EXISTS

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

Line 125: FROM dual where NOT EXISTS

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