APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on MTL_DEFAULT_SETS_VIEW

Line 1984: mtl_default_sets_view mdsv,

1980: purchase_basis <> 'TEMP LABOR' and
1981: order_type_lookup_code <> 'FIXED PRICE' and
1982: not exists (SELECT '1'
1983: FROM mtl_system_items_kfv msi,
1984: mtl_default_sets_view mdsv,
1985: mtl_item_categories mic,
1986: mtl_categories_kfv mck
1987: WHERE msi.concatenated_segments = p1.item_number and
1988: msi.organization_id = l_inventory_org_id and

Line 2024: mtl_default_sets_view mdsv,

2020: (item_number = 'ITEM_NUMBER_NONE_ENTERED') OR
2021: (item_number <> 'ITEM_NUMBER_NONE_ENTERED' and
2022: not exists (select '1'
2023: from mtl_system_items_kfv msi,
2024: mtl_default_sets_view mdsv,
2025: mtl_item_categories mic,
2026: mtl_categories_kfv mck
2027: where msi.concatenated_segments = p1.item_number and
2028: msi.organization_id = l_inventory_org_id and

Line 2072: from mtl_default_sets_view mdsv,

2068: -- default the category if not entered for valid item numbers
2069:
2070: update pon_item_prices_interface p1
2071: set category_name = (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2072: from mtl_default_sets_view mdsv,
2073: mtl_item_categories mic,
2074: mtl_categories_kfv mck
2075: where mdsv.functional_area_id = 2 and
2076: mic.inventory_item_id = p1.item_id and

Line 2359: from mtl_default_sets_view mdsv,

2355: purchase_basis <> 'TEMP LABOR' and
2356: order_type_lookup_code <> 'FIXED PRICE' and
2357: item_number is not null and
2358: category_name <> (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2359: from mtl_default_sets_view mdsv,
2360: mtl_item_categories mic,
2361: mtl_categories_kfv mck
2362: where mdsv.functional_area_id = 2 and
2363: mic.inventory_item_id = p1.item_id and