APPS.INV_MGD_POS_ITEM_MDTR dependencies on MTL_ITEM_CATEGORIES

Line 111: FROM mtl_item_categories mic

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

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)

Line 150: FROM mtl_item_categories mic

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

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

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

Line 221: -- need to join to mtl_item_categories;

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