APPS.INV_MGD_POS_ITEM_MDTR dependencies on MTL_ITEM_CATEGORIES

Line 112: FROM mtl_item_categories mic

108: , p_category_id NUMBER
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)

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)

Line 151: FROM mtl_item_categories mic

147: ) IS
148: SELECT msi.organization_id
149: , msi.inventory_item_id
150: , msi.segment1
151: FROM mtl_item_categories mic
152: , mtl_system_items_b msi
153: WHERE msi.organization_id = p_organization_id
154: AND msi.segment1
155: BETWEEN NVL(p_item_from, msi.segment1) AND NVL(p_item_to,msi.segment1)

Line 175: -- don't need to join to mtl_item_categories

171: x_item_tbl.DELETE;
172:
173: IF p_category_id IS NULL THEN
174:
175: -- don't need to join to mtl_item_categories
176: IF G_DEBUG = 'Y' THEN
177: INV_MGD_POS_UTIL.Log
178: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
179: , p_msg => 'build item list without category filter'

Line 222: -- need to join to mtl_item_categories;

218: END;
219:
220: ELSE
221:
222: -- need to join to mtl_item_categories;
223: IF G_DEBUG = 'Y' THEN
224: INV_MGD_POS_UTIL.Log
225: ( p_priority => INV_MGD_POS_UTIL.G_LOG_STATEMENT
226: , p_msg => 'build item list with category filter'