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 MTL_SYSTEM_ITEMS_KFV

Line 81: FROM mtl_system_items_kfv msik

77: */
78: /* UNION part from query is deleted for better performance. Bug 4951736
79: SELECT organization_id
80: , inventory_item_id
81: FROM mtl_system_items_kfv msik
82: WHERE organization_id = p_organization_id
83: AND concatenated_segments
84: BETWEEN NVL(p_item_from,concatenated_segments) AND NVL(p_item_to,concatenated_segments)
85: -- Following union clause added for bug 4357322

Line 89: ( SELECT 1 FROM mtl_system_items_kfv

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)
93: ) ;

Line 97: FROM mtl_system_items_kfv msik

93: ) ;
94: */
95: SELECT organization_id
96: , inventory_item_id
97: FROM mtl_system_items_kfv msik
98: WHERE organization_id = p_organization_id
99: AND concatenated_segments
100: BETWEEN NVL(p_item_from,concatenated_segments) AND NVL(p_item_to,concatenated_segments);
101:

Line 113: , mtl_system_items_kfv msik

109: ) IS
110: SELECT msik.organization_id
111: , msik.inventory_item_id
112: FROM mtl_item_categories mic
113: , mtl_system_items_kfv msik
114: WHERE msik.organization_id = p_organization_id
115: AND msik.concatenated_segments
116: BETWEEN NVL(p_item_from, msik.concatenated_segments)
117: AND NVL(p_item_to,msik.concatenated_segments)

Line 127: ( SELECT 1 FROM mtl_system_items_kfv msik, mtl_item_categories mic

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)
131: AND NVL(p_item_to,msik.concatenated_segments)