[Home] [Help]
2170: purchase_basis <> 'TEMP LABOR' and
2171: order_type_lookup_code <> 'FIXED PRICE' and
2172: not exists (SELECT '1'
2173: FROM mtl_system_items_kfv msi,
2174: mtl_default_sets_view mdsv,
2175: mtl_item_categories mic,
2176: mtl_categories_kfv mck
2177: WHERE msi.concatenated_segments = p1.item_number and
2178: msi.organization_id = l_inventory_org_id and
2210: (item_number = 'ITEM_NUMBER_NONE_ENTERED') OR
2211: (item_number <> 'ITEM_NUMBER_NONE_ENTERED' and
2212: not exists (select '1'
2213: from mtl_system_items_kfv msi,
2214: mtl_default_sets_view mdsv,
2215: mtl_item_categories mic,
2216: mtl_categories_kfv mck
2217: where msi.concatenated_segments = p1.item_number and
2218: msi.organization_id = l_inventory_org_id and
2264: -- default the category if not entered for valid item numbers
2265:
2266: update pon_item_prices_interface p1
2267: set category_name = (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2268: from mtl_default_sets_view mdsv,
2269: mtl_item_categories mic,
2270: mtl_categories_kfv mck
2271: where mdsv.functional_area_id = 2 and
2272: mic.inventory_item_id = p1.item_id and
2558: purchase_basis <> 'TEMP LABOR' and
2559: order_type_lookup_code <> 'FIXED PRICE' and
2560: item_number is not null and
2561: category_name <> (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2562: from mtl_default_sets_view mdsv,
2563: mtl_item_categories mic,
2564: mtl_categories_kfv mck
2565: where mdsv.functional_area_id = 2 and
2566: mic.inventory_item_id = p1.item_id and