[Home] [Help]
1979: upper(order_type_lookup_code) <> upper('AMOUNT') and
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
2019: (purchase_basis = 'GOODS' AND
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
2048: (select msi.inventory_item_id,
2049: decode(p1.item_description, 'ITEM_NONE_ENTERED', msitl.description, p1.item_description),
2050: msi.allow_item_desc_update_flag,
2051: decode(p1.unit_of_measure, 'UOM_NONE_ENTERED', uom.unit_of_measure_tl, p1.unit_of_measure)
2052: from mtl_system_items_kfv msi,
2053: mtl_system_items_tl msitl,
2054: mtl_units_of_measure_tl uom
2055: where msi.concatenated_segments = p1.item_number and
2056: msi.organization_id = l_inventory_org_id and
2104: purchase_basis <> 'TEMP LABOR' and
2105: item_number is not null and
2106: allow_item_desc_update_flag = 'N' and
2107: item_description <> (select msitl.description
2108: from mtl_system_items_kfv msi,
2109: mtl_system_items_tl msitl
2110: where msi.inventory_item_id = p1.item_id and
2111: msi.organization_id = l_inventory_org_id and
2112: msi.inventory_item_id = msitl.inventory_item_id and
2807: and ip.need_by_date is null
2808: and ip.need_by_start_date is null
2809: and ip.item_id is not null
2810: and exists ( SELECT 'x'
2811: FROM mtl_system_items_kfv msi,
2812: financials_system_params_all fsp
2813: WHERE nvl(fsp.org_id, -9999) = nvl(p_org_id,-9999)
2814: and msi.organization_id = fsp.inventory_organization_id
2815: and msi.inventory_item_id = ip.item_id