APPS.CHV_BUILD_SCHEDULES dependencies on MTL_ITEM_CATEGORIES

Line 163: from mtl_item_categories mic

159: AND (p_category_set_id is null
160: OR
161: paa.item_id in (
162: select mic.inventory_item_id
163: from mtl_item_categories mic
164: where mic.category_set_id = p_category_set_id
165: and mic.organization_id = x_organization_id
166: and nvl(p_category_id,mic.category_id) = mic.category_id))
167: AND nvl(paa.enable_autoschedule_flag,'N') = 'N'

Line 231: from mtl_item_categories mic

227: AND (p_category_set_id is null
228: OR
229: paa.item_id in (
230: select mic.inventory_item_id
231: from mtl_item_categories mic
232: where mic.category_set_id = p_category_set_id
233: and mic.organization_id = x_organization_id
234: and nvl(p_category_id,mic.category_id) = mic.category_id))
235: AND nvl(paa.enable_autoschedule_flag, 'N') = 'Y'

Line 1429: from mtl_item_categories mic

1425: AND (p_category_set_id is null
1426: OR
1427: paa.item_id in (
1428: select mic.inventory_item_id
1429: from mtl_item_categories mic
1430: where mic.category_set_id = p_category_set_id
1431: and mic.organization_id = x_organization_id
1432: and nvl(p_category_id,mic.category_id) = mic.category_id))
1433: AND nvl(p_autoschedule_flag,'N') = nvl(paa.enable_autoschedule_flag, 'N')