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 80: FROM mtl_system_items_kfv msik

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

Line 88: ( SELECT 1 FROM mtl_system_items_kfv

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

Line 96: FROM mtl_system_items_kfv msik

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

Line 112: , mtl_system_items_kfv msik

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

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

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