[Home] [Help]
801: begin
802: select 'Y' into l_exists
803: from mtl_system_items_b
804: where inventory_item_id = p_Item_Orderability_Import_Rec.inventory_item_id
805: and organization_id = oe_sys_parameters.value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id );
806: Exception
807: when no_data_found then
808: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
809: fnd_message.set_token('ATTRIBUTE','INVENTORY_ITEM_ID');
892: mtl_default_category_sets cs,
893: oe_item_orderability oei
894: WHERE ic.category_set_id=cs.category_set_id
895: AND cs.functional_area_id = 7
896: AND ic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id)
897: AND ic.inventory_item_id = p_Item_Orderability_Import_Rec.inventory_item_id
898: AND oei.enable_flag='Y'
899: AND ic.category_id = oei.item_category_id
900: and org_id = p_Item_Orderability_Import_Rec.org_id
957: mtl_default_category_sets cs,
958: oe_item_orderability oei
959: WHERE ic.category_set_id=cs.category_set_id
960: AND cs.functional_area_id = 7
961: AND ic.organization_id=oe_sys_parameters.Value('MASTER_ORGANIZATION_ID',p_Item_Orderability_Import_Rec.org_id)
962: AND ic.inventory_item_id = oei.inventory_item_id
963: AND oei.enable_flag='Y'
964: AND ic.category_id = p_Item_Orderability_Import_Rec.ITEM_CATEGORY_ID
965: and org_id = p_Item_Orderability_Import_Rec.org_id